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] -----------------------------------------------------------------------------