DB/Oracle
[Oracle] time zone, utc, local time
냐옴
2015. 11. 2. 22:54
SELECT
SYSTIMESTAMP
, TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS TZR')
, TO_CHAR(SYS_EXTRACT_UTC(SYSTIMESTAMP), 'YYYY-MM-DD HH24:MI:SS TZR')
, TO_CHAR(FROM_TZ(SYS_EXTRACT_UTC(SYSTIMESTAMP), 'UTC') AT TIME ZONE '+08:00', 'YYYY-MM-DD HH24:MI:SS TZR')
FROM DUAL