Lloyd <[EMAIL PROTECTED]> writes: > 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 ?
You may want: select datetime(sdate, 'unixepoch', 'localtime') from mytab; Derrell ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------