Old revisions Add to book Export to PDF Book Creator Add this page to your book Book Creator Remove this page from your book Manage book (0 page(s)) Help BioStar 1, Oracle, Time, Date 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;