ORACLE-to-date conversion between milliseconds

Milliseconds converted to date

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

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 ')) * 24 * 60 * 60 * 1000        

Get System Current Time

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

Attention:milliseconds converted to dateThe formatted time can be a 12-hour and 24-hour system.