develog

[Oracle] time zone 본문

DB/Oracle

[Oracle] time zone

냐옴 2015. 8. 4. 18:55

SELECT *

FROM V$TIMEZONE_NAMES

;


SELECT SESSIONTIMEZONE, DBTIMEZONE

FROM DUAL

;


SELECT CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP

FROM DUAL

;


ALTER SESSION SET TIME_ZONE='+09:00';

ALTER SESSION SET TIME_ZONE='+00:00';


저작자표시

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

[Oracle] UTC time  (0) 2015.08.05
[Oracle] NLS parameters  (0) 2015.08.04
[Oracle] Trigger 생성  (0) 2015.06.19
[Oracle] REF CURSOR  (0) 2015.06.18
[Oracle] DDL, DML, DCL, TCL  (0) 2015.05.13
'DB/Oracle' Related Articles more
Comments