【课堂笔记】【SQL】16.Managing Data in Different Time Zones

5dm

时区的划分是以英国的Greenwich为基准

时区：

 

TIME_ZONE may be set to:

?An absolute offset

?Database time zone

?OS local time zone

?A named region

 

示例： 

ALTER SESSION SET TIME_Z;

ALTER SESSION SET TIME_ZONE = dbtimezone;

ALTER SESSION SET TIME_ZONE = local;

ALTER SESSION SET TIME_Z;

修改回话时间示例：

ALTER SESSION

SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

ALTER SESSION SET TIME_Z;

SELECT SESSIONTIMEZONE, CURRENT_DATE FROM DUAL;

ALTER SESSION SET TIME_Z;
SELECT SESSIONTIMEZONE, CURRENT_DATE FROM DUAL;