--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 dualSelectTO_DATE('01-jan-1970', 'dd-mon-yyyy') + 1462086000/86400 fromdual