Old revisions Add to book Export to PDF Fold/unfold all 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;