Time zone settings for the database operations database (server) and time zones in major regions of the world

"What's wrong with the time zone setting is inappropriate"

When carrying out overseas project operations, often encounter time zone settings, if the time zone is not set up or the same project is inconsistent between the server, there will be the risk of data anomalies that cause the project.
If the Data table field uses a Date Type field, the default value for the field is Sysdate, and the default value of the field is used when the program inserts the record, it is possible to cause data exceptions. It is also prudent to modify the time zone of the database server.

"Method of server time synchronization"

# time synchronization Server please modify the address requested (the address of Windows is recommended because most PCs in the world use the Windows operating system.) According to CNZZ data, in the domestic operating system market, in January 2014, Microsoft Windows system still dominate the market, the share of 90.63%)

Physical server Environment:

*/10 * * * * */usr/sbin/ntpdate-u time.windows.com; /sbin/clock-w >>/tmp/clock.log

Virtual Machine Environment:

*/10 * * * */usr/sbin/ntpdate-u time.windows.com >>/tmp/clock.log

"How to modify the time zone settings for an item on line"

Replacing/etc/localtime will take effect immediately on the operating system, but if the operating system is running with database program software, the database will not take effect immediately and the database must be restarted. Therefore, if the current time zone of the database is already a problem, it is recommended to maintain the status quo or with the development of the program to confirm, give a feasible solution, in the database maintenance, modify the time zone. Of course, for a database that has just been installed without any business data, you can re-install the database after modifying the operating system time zone, and it is no problem to protect the time zone of the database metadata.

Remember: Can not fail, if do have the risk of failure, and do not do to maintain the status quo, then do nothing is a good choice.

"Time zones and setting methods for overseas regions"

#################### Set TimeZone #############################

# TIMEZONE:UTC+8,CST

# Area:china
Ln-fs/usr/share/zoneinfo/asia/shanghai/etc/localtime
Sed-i ' s/^zone.*/zone= "Asia\/shanghai"/g '/etc/sysconfig/clock

# TIMEZONE:UTC+8,SGT
# Area:singapore
Ln-fs/usr/share/zoneinfo/singapore/etc/localtime
Sed-i ' s/^zone.*/zone= "Singapore"/g '/etc/sysconfig/clock

# timezone:utc+7,ict
# Area:vietnam
Ln-fs/usr/share/zoneinfo/asia/ho_chi_minh/etc/localtime
Sed-i ' s/^zone.*/zone= "asia\/ho_chi_minh"/g '/etc/sysconfig/clock

# Timezone:utc-8,pst
# Area:us, California
Ln-sf/usr/share/zoneinfo/america/los_angeles/etc/localtime
Sed-i ' s/^zone.*/zone=zone= "america\/los_angeles"/g '/etc/sysconfig/clock

# Timezone:utc+8,est
# Area:au
/usr/share/zoneinfo/australia/sydney
Ln-sf/usr/share/zoneinfo/australia/sydney/etc/localtime
Sed-i ' s/^zone.*/zone=zone= "Australia\/sydney"/g '/etc/sysconfig/clock

# Timezone:utc+1,cest
# Area:german
Ln-fs/usr/share/zoneinfo/europe/berlin/etc/localtime
Sed-i ' s/^zone.*/zone=zone= "europe\/berlin"/g '/etc/sysconfig/clock

Time zone

Wikipedia: Http://zh.m.wikipedia.org/wiki/%E6%97%B6%E5%8C%BA%E5%88%97%E8%A1%A8