David Wellman wrote: > The question has come up as to how we should store date/time values in our > tables? Basically how should we define our date/time columns?
SQLite does not have a separate date/time type. If you want to use the built-in date/time function, you can store values in one of three different formats: http://www.sqlite.org/datatype3.html#datetime > in the application code we're dealing with MS serial date values. That is not one of SQLite's supported formats. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
