Oracle Date type을 milliseconds로 변환하기

2024. 11. 23. 23:21Data/Oracle

UTC 표준시간

SELECT 
    (SYSDATE - TO_DATE('1970-01-01', 'YYYY-MM-DD')) * 24 * 60 * 60 * 1000 AS milliseconds
FROM dual;

Lcoal 한국시간

SELECT 
    (SYSDATE - TO_DATE('1970-01-01 09:00', 'YYYY-MM-DD HH:MI')) * 24 * 60 * 60 * 1000 AS milliseconds
FROM dual;