William Drago wrote: > I am using SQLite with C# and am having trouble with SQLite DATETIME > types.
In SQLite, the DATETIME type is interpreted in the same way as the FLUFFY_BUNNIES type, i.e., it is not recognized at all. Due to SQLite's dynamic typing, values in that column have the same type that they were inserted as: <http://www.sqlite.org/datatype3.html>. > The following error occurs when trying to read rows from a table that > contains dates (e.g. "12/09/2012 22:51:24"). Is that ninth December or twelfth September? Date/times are can be stored as number or strings; strings should have the format 'yyyy-mm-dd hh:mm:ss': <http://www.sqlite.org/lang_datefunc.html> Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
