, , ,

Oracle query - Time and date conversion

How to convert time and date stored in the TB_EVENT_LOG table to a normal format

SELECT TO_CHAR(TO_DATE('19700101000000', 'yyyymmddhh24miss') + 1/(24*60*60) * nDateTime,
'yyyy-mm-dd hh24:mi:ss') "sLogTime" FROM TB_EVENT_LOG;