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
