NSFullTimeZones View
Provides a view of the time zone codes used by Notification Services. This view returns one row for each time zone in each of the nine languages that SQL Server is published in.
The information about time zones that the NSFullTimeZones view contains is shown in the following table.
| Column | Data type | Description |
|---|---|---|
TimeZoneId |
smallint |
The time zone ID number. |
TimeZoneName |
nchar(35) |
The name of the time zone in English. |
UtcOffset |
int |
The integer difference between the time zone time and Coordinated Universal Time (UTC). |
Language |
nvarchar(6) |
One of the nine SQL Server languages. |
LocationName |
nvarchar(100) |
The name of the time zone location in the specified language. |
DisplayName |
nvarchar(100) |
The display name of the time zone, including the number of hours' difference from Greenwich Mean Time and the locations that use the time zone. |
DaylightName |
nvarchar(100) |
The name of daylight savings time in the specified language. |
StandardName |
nvarchar(100) |
The name of standard time in the specified language. |
Remarks
The NSFullTimeZones view is located in the instance database.
Permissions
This view is available to members of the NSSubscriberAdmin database role and the sysadmin and db_owner server roles.