develog

[Oracle] SYSTIMESTAMP time zone 본문

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



저작자표시

'DB > Oracle' 카테고리의 다른 글

[Oracle] RECYCLEBIN, 휴지통 비우기  (0) 2016.02.04
[Oracle] function-based index 조회  (0) 2016.02.04
[Oracle] time zone, utc, local time  (0) 2015.11.02
[Oracle] time zone  (0) 2015.11.02
[Oracle] NLS parameter  (0) 2015.10.30
'DB/Oracle' Related Articles more
Comments