On Sep 28, 2011, at 4:48 PM, Puneet Kishor wrote: > But, if I understood [http://www.sqlite.org/datatype3.html] correctly, there > really is no such thing as DATETIME value. Internally, it is stored as TEXT > anyway.
Or as a number. Your choice: • TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS"). • REAL as Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C. according to the proleptic Gregorian calendar. • INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC. Considering the amount of data you have, perhaps something like a unix time would be more, hmmm, more frugal. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users