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.
There is a set of embedded functions which implement dates and times using 64 bit floating point numbers. In applications requiring it we have declared types DATE, TIMAE and DATEIME. These are intercepted in a wrapper and implement date and time processing. Alternatively you can use regular ISO1806 date and time formaats as TEXT or use the floaring point and handle dates and times in your application. Sqlite gives you a lot of options when embedding date and time storage and prcessing. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users