need help converting epoch time to human readable date & time
Hi All,
I am using a linked server in SQL 2005 to pull data from ORACLE DB. but the problem i am having is how to convert the epoch time from "11111111111" number to a readable date...here is my code:
the date & time column is called : create_date
SELECT * FROM OPENQUERY(LINKED_ORA,
'SELECT
TO_DATE(MOD(CREATE_DATE, 86400), ''SSSSS''),''MM/DD/YYYY HH24:MI:SS '' as CREATEDATE
FROM CLIENT_TABLE');
GO
it still not working ..
any help will be greatly appreciated.
thanks