Daylight savings time can cause problems in a distributed database system if data is synchronized during the hour that the time changes. In fact, you can lose data. This is only an issue in the autumn when the time goes back and there is a one-hour period that can be ambiguous.
To deal with daylight savings time, you have three possible solutions:
Ensure that the consolidated database server is using UTC time.
Turn off daylight savings time on the consolidated database server.
Shut down for an hour when the time changes.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|