Lloyd wrote:
select datetime(1162961284,'unixepoch','localtime');
2006-11-08 10:18:04
The result is correct.
I would like to know how sqlite is performing the localtime correction.
timestamps are in relation to UTC.. When you use the localtime modifier,
you are instructing the code to adjust the timestamp display in
accordance with your local settings. IOW, the offset from UTC of your
system is used in the calculation of the displayed date.
Google: "strftime", "asctime" and "localtime" for a better explanation.
--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
Controlling pseudoephedrine purchases.
http://www.mtsprofessional.com/
A Win32 email server that works for You.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------