UCT vs. local time, perchance? Markus
Lloyd <[EMAIL PROTECTED]> was heard to say: > Hi, > I stored a unix epoch (32 bit integer) date in the sqlite data base. I > want to retrieve it in the readable date format. For that I use the > following query > > select datetime(sdate,'unixepoch') from mytab; > > It shows a formatted date, but there is some changes in the hours. > > How can I retrieve the accurately converted date and time ? > > Thanks, > Lloyd. > > > ______________________________________ > Scanned and protected by Email scanner > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
