[복사되는블로그 꼬마갱이] 밀리세컨드 변환

SELECT A + B AS dat
FROM(
SELECT
TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AS A
, (1179531250785 / 1000) / 86400 AS B
FROM dual
)

select TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') + (1179531250785/1000) / 3600 a from dual

 

 

 

by 꼬마갱이 2008-01-16