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

Source: Internet
Author: User
Tags time zones

"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


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.