DB/Oracle
[Oracle] SYSTIMESTAMP time zone
냐옴
2016. 2. 3. 10:06
SYSTIMESTAMP 는 OS time zone을 리턴
SELECT DBTIMEZONE , SESSIONTIMEZONE , TO_CHAR(SYSTIMESTAMP, 'TZH:TZM') SYSTIMESTAMP_TIMEZONE FROM DUAL |
DBTIMEZONE
+00:00
SESSIONTIMEZONE
+09:00
SYSTIMESTAMP TIMEZONE
+08:00