develog

[Oracle] time zone 본문

DB/Oracle

[Oracle] time zone

냐옴 2015. 11. 2. 19:50

SELECT DISTINCT TZNAME

FROM V$TIMEZONE_NAMES

WHERE TZNAME LIKE '%Seoul%'

;


SELECT TZ_OFFSET('Asia/Seoul') 

FROM DUAL

;



저작자표시

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

[Oracle] SYSTIMESTAMP time zone  (0) 2016.02.03
[Oracle] time zone, utc, local time  (0) 2015.11.02
[Oracle] NLS parameter  (0) 2015.10.30
[Oracle] 제품 버전 확인  (0) 2015.10.29
[Oracle] DBMS_OUTPUT no limit  (0) 2015.08.20
'DB/Oracle' Related Articles more
Comments