Export (0) Print
Expand All

NSFullTimeZones View

SQL Server 2005

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.

The NSFullTimeZones view is located in the instance database.

This view is available to members of the NSSubscriberAdmin database role and the sysadmin and db_owner server roles.

Community Additions

ADD
Show:
© 2014 Microsoft