On Aug 1, 2005, at 7:57 AM, Griggs, Donald wrote:
Re:
Wonder what the best way is to store a date (and time).
Hello Edwin,
If you haven't already, you'll want to read about the sqlite date/time
functions at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I am curious about this as well... not about the various functions, but
what is, if at all, a better way to store the values -- as 'YYYY-MM-DD
HH:MM:SS' strings (are they not stored internally as just strings?) or
as unixepoch time (which would likely be stored as an int)?
Is not the latter (unixepoch) faster than the former ('YYYY-MM-DD
HH:MM:SS' strings)?
Is one more malleable than the other for conversion into various other
display forms as well as for DATETIME calculations?
--
Puneet Kishor
