SELECT ROUND(EXTRACT(SECOND
FROM(TO_TIMESTAMP('1970-01-01 08:00:00.000',
'YYYY-MM-DD HH24:MI:SS.FF3') +
NUMTODSINTERVAL(1709170120518 / 1000, 'SECOND') -
(TO_TIMESTAMP('1970-01-01 08:00:00.000',
'YYYY-MM-DD HH24:MI:SS.FF3') +
NUMTODSINTERVAL(1709170099840 / 1000, 'SECOND'))))) AS TIME_DIFFERENCE_SECONDS
FROM DUAL;
Oracle时间戳转换
于 2024-03-20 19:23:03 首次发布