Oracle Date type을 milliseconds로 변환하기
UTC 표준시간SELECT (SYSDATE - TO_DATE('1970-01-01', 'YYYY-MM-DD')) * 24 * 60 * 60 * 1000 AS millisecondsFROM dual;Lcoal 한국시간SELECT (SYSDATE - TO_DATE('1970-01-01 09:00', 'YYYY-MM-DD HH:MI')) * 24 * 60 * 60 * 1000 AS millisecondsFROM dual;
2024.11.23