1.以timestamp with time zone数据类型返回当前会话时区中的当前日期

SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
10-JUL-22 02.12.02.482396 PM +08:00

2.开启另外一个session

[root@db02 ~]# date -s 16:36:00
Sun Jul 10 16:36:00 CST 2022

3.再次查看时间，current_timestam获取当前OS时间。http://www.cndba.cn/hbhe0316/article/108530http://www.cndba.cn/hbhe0316/article/108530http://www.cndba.cn/hbhe0316/article/108530

SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
10-JUL-22 04.36.07.895090 PM +08:00

4.当我们修改时区，再次查看current_timestamp的值http://www.cndba.cn/hbhe0316/article/108530http://www.cndba.cn/hbhe0316/article/108530http://www.cndba.cn/hbhe0316/article/108530http://www.cndba.cn/hbhe0316/article/108530

SQL> alter session set time_zone='+09:00';

Session altered.

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
--------------------------------------------------------------------------------
+09:00

SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
10-JUL-22 05.42.29.012981 PM +09:00

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle