How can I convert an Epoch timestamp to a timestamp using SQL Anywhere? For example: Input Epoch timestamp: 1354320000 Desired output Timestamp: 2012-12-01 00:00:00 Human time (GMT): Sat, 01 Dec 2012 00:00:00 GMT |
EPOC time is the number of seconds since 1970 Jan 1.... so use: select dateadd( SECOND, 1354320000, '1970-1-1' ) |
Mark your answer has the extra ".000000" I think this is what I need to do, right? --CONVERT FROM EPOCH TO DATETIME: SELECT DATEFORMAT(dateadd(SS,CONVERT(INT, 1354320000), CAST('1970-01-01 00:00:00' as datetime) ), 'yyyy-mm-dd hh:mm:ss') as myDateTime; ---CONVERT FROM DATETIME TO EPOCH GMT+0: SELECT CAST(datediff(ss, 'Jan 01 1970', '2012-12-01 00:00:00' ) AS CHAR) as myEpochDate; |