oracle怎么修改时区

SQL> select dbtimezone from dual; DBTIMEZONE------------+00:00

2、查看会话时区

SQL> select sessiontimezone from dual; SESSIONTIMEZONE--------------------------------------------------------------------------------+08:00

可以看到会话时区是北京时区。和数据库 时区不一致。

3、修改数据库的时区为CST

alter database set time_zOne='+8:00'; SQL> alter database set time_zOne='+8:00'; Database altered.

4、重启数据库

SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started. Total System Global Area 784998400 bytesFixed Size 2257352 bytesVariable Size 478154296 bytesDatabase Buffers 301989888 bytesRedo Buffers 2596864 bytesDatabase mounted.Database opened.SQL> select sessiontimezone, dbtimezone from dual; SESSIONTIMEZONE--------------------------------------------------------------------------------DBTIMEZONE------------+08:00+08:00

推荐教学：《Oracle视频教学》