ORACLE Millisecond to date mutual conversion example _oracle

Millisecond conversion to date

SELECT To_char (1406538765000/1000) + 
to_date (' 1970-01-01 08:00:00 ', ' yyyy-mm-dd HH:MI:SS '), ' yyyy-mm -dd HH24:MI:SS ') as CDATE from 
DUAL;

Date conversion milliseconds

SELECT To_number (to_date (' 2014-07-28 17:12:45 ', ' yyyy-mm-dd HH24:MI:SS ')- 
to_date (' 1970-01-01 8:0:0 ', ' Yyyy-mm-dd HH24:MI:SS ')) * * * 1000 from 
DUAL;

Get System Current Time

Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual;

Note: The milliseconds to date format can be a 12-hour system and a 24-hour system.