오라클 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 <= 25
)
SELECT 
     SDT
    ,EDT
    ,TO_CHAR(SDT AT TIME ZONE 'Asia/Seoul','YYYY-MM-DD HH24:MI:SS') SDT_SEOUL
    ,TO_CHAR(SDT AT TIME ZONE 'US/Eastern','YYYY-MM-DD HH24:MI:SS') SDT_EASTERN
    ,TO_CHAR(SDT AT TIME ZONE 'America/New_York','YYYY-MM-DD HH24:MI:SS') SDT_NEWYORK
    ,TO_CHAR(EDT AT TIME ZONE 'Asia/Seoul','YYYY-MM-DD HH24:MI:SS') EDT_SEOUL
    ,TO_CHAR(EDT AT TIME ZONE 'US/Eastern','YYYY-MM-DD HH24:MI:SS') EDT_EASTERN
    ,TO_CHAR(EDT AT TIME ZONE 'America/New_York','YYYY-MM-DD HH24:MI:SS') EDT_NEWYORK
    ,TO_CHAR(SYSTIMESTAMP AT TIME ZONE 'Asia/Seoul','YYYY-MM-DD HH24:MI:SS') CURRENT_SEOUL
    ,TO_CHAR(SYSTIMESTAMP AT TIME ZONE 'US/Eastern','YYYY-MM-DD HH24:MI:SS') CURRENT_EASTERN
    ,TO_CHAR(SYSTIMESTAMP AT TIME ZONE 'America/New_York','YYYY-MM-DD HH24:MI:SS') CURRENT_NEWYORK
    ,TO_CHAR(SYSTIMESTAMP AT TIME ZONE 'EST','YYYY-MM-DD HH24:MI:SS') CURRENT_EST
FROM TBL;

SELECT * FROM V$TIMEZONE_NAMES;