Cross-region time of SQL Server databases

Recently, I encountered a problem: Solving the Problem of displaying the time of American and Chinese companies. The current database records the United States time and displays the China time zone on the Chinese webpage. And consider the issue of timeout.

The SQL Server 2005 data time format does not support international time zones.

The time format of SQL Server 2008 solves the time zone problem. Provides the related data class new datetimeoffset type and related functions.

After SQL Server 2008, the database has enhanced the time format type. A new data type datetimeoffset for time internationalization is added and a series of related functions are provided. Because this time type records the time zone of the time, it may be helpful for the multi-language setting of clims4.

In addition, the old-fashioned datatime data type may be replaced by the datetime2 type. We recommend that you use the datetime type with caution in the future.

The switchdatatimesoffset function does not support the change during renewal. As follows:

Is a character string in the format [+ |-] tzh: tzm or a signed integer (of minutes) that represents the time zone offset, andIs assumed to be daylight-saving aware and adjusted.