重庆思庄Oracle、Redhat认证学习论坛

标题: 【课堂笔记】【SQL】16.Managing Data in Different Time Zones [打印本页]

---

作者: 5dm    时间: 2012-11-5 16:23
标题: 【课堂笔记】【SQL】16.Managing Data in Different Time Zones

时区的划分是以英国的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;

 

 

 

---

欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2