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;
本文标题：Oracle获取当前Unix时间戳（秒）
本文链接：https://www.haomeiwen.com/subject/jadqshtx.html
网友评论