Oracle获取当前Unix时间戳(秒)
2020-03-13 本文已影响0人
Pan丶Gu
SQL > SELECT ( to_date('2017-07-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') - to_date('1970-1-1 8', 'yyyy-mm-dd hh24') ) * 86400 AS unix_timestamp FROM DUAL;
SQL > SELECT ( to_date('2017-07-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') - to_date('1970-1-1 8', 'yyyy-mm-dd hh24') ) * 86400 AS unix_timestamp FROM DUAL;