TimeZone
- Last UpdatedMar 10, 2025
- 1 minute read
Contains one row for each time zone as defined by the Windows operating system. This table is automatically populated by the system.
|
Column |
Data Type |
Description |
|---|---|---|
|
(PK) TimeZoneID |
smallint NULL |
The unique numerical identifier for the time zone. |
|
TimeZone |
nvarchar(100) NULL |
The name of the time zone. |
|
Description |
nvarchar(100) NULL |
The description of the time zone that includes the hour offset from UTC (GMT) and major cities or regions in the time zone. |
|
Offset |
smallint NOT NULL |
The offset, in minutes, for daylight savings time, when in effect. |
|
RegistryName |
nvarchar(100) NULL |
The Windows registry name of the time zone, which is always in English. |