Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

epoch

--Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
--please drop objects you've created at the end of the script 
--or check for their existance before creating
--'\\' is a delimiter

--select (sysdate-to_date('1-1-1970 00:00:00','MM-DD-YYYY HH24:Mi:SS'))*24*3600 n from dual
Select TO_DATE('01-jan-1970',   'dd-mon-yyyy') + 1462086000/86400 from dual
 run  | edit  | history  | help 0