sqlfan wrote: > I'm very new to sqlite but I notice there is no way to mark a column as > containing dates... What is the standard way to do operations with dates, > please, and to store dates? Should I try the format 20080405 and do my own > calculations using my language's standard library? (I'm using Python) or is > there a better way to store dates? Thank you for all your help. I'm very > new to all this. > See http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions for info on date and time functions.
I would suggest storing dates as floating point julian day numbers. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
