Thanks Craig Morrison. Now I got the idea clearly. On Wed, 2006-11-08 at 00:55 -0500, Craig Morrison wrote: > 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. >
______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------