Oracle's Sysdate and Linux systems have inconsistent date times

1. Oracle's time zone can be divided into two, one is the time zone of the database, one is the session time zone, that is, the time zone when the client connects

Select Sessiontimezone from dual; (Client connection time zone)

Select Dbtimezone from dual; (Database time zone)

2. Modify the time zone of the database: Alter DB set time_zone= ' +08:00 '

3. Restart Oracle

Http://jingyan.baidu.com/article/86fae346870c503c49121a96.html

Oracle's Sysdate and Linux systems have inconsistent date times