반응형

목록2017/12/17 (1)

DBILITY

오라클 SQL 썸머타임(일광절약시간) 테스트

여러모로 귀찮다 WITH TBL (SDT,EDT) AS ( SELECT TO_TIMESTAMP_TZ('2017-03-12 11:00:00', 'yyyy-mm-dd hh24:mi:ss') + NUMTODSINTERVAL(LEVEL-1 , 'HOUR') SDT ,TO_TIMESTAMP_TZ('2017-11-05 11:00:00', 'yyyy-mm-dd hh24:mi:ss') + NUMTODSINTERVAL(LEVEL-1 , 'HOUR') EDT FROM DUAL CONNECT BY LEVEL
database/oracle 2017. 12. 17. 09:21
Prev 1 Next
반응형