Just a quick query. I want to store dates and work with them in my SQLite database. There's no specific need for any calculations to done on one side or another (i.e. it's a single user database).
I googled how to work with dates in SQL, and I got one like this -
SELECT * FROM totp WHERE wk BETWEEN '1980/05/20' AND '1980/05/26'
as an example of finding a range for a date. I'm not too sure about how SQL works with dates (and times for that matter), so I'm tempted to stick to what I know and just store dates/times as strings in the db, and then use them to create datetime objects when needed.
I have not worked much with sqlite, but from this page: http://www.sqlite.org/datatype3.html it appears that sqlite does not have a date datatype.
theDateTime = datetime.datetime(intD[0], intD[1], intD[2], intT[0], intT[1])
Although working with dates like that doesn't seem that flash either.
Well... create a wrapper function to clean it up, right?
Alternatively, I was thinking of storing the actual datetime object in the database (this is a blob I believe?), and that's a whole new kettle of fish.
I have heard a lot of really good things about SQLObject: http://sqlobject.org/
However, that requires a more full-featured database, like postgresql.
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
