Table of Contents

Class ServerWideConfigurationSchema.TimeZoneInfo

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.time_zone_info (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics

Returns information about supported time zones. All time zones installed on the computer are stored in the following registry hive:
KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.


See sys.time_zone_info.

[Table(Schema = "sys", Name = "time_zone_info", IsView = true)]
public class ServerWideConfigurationSchema.TimeZoneInfo
Inheritance
ServerWideConfigurationSchema.TimeZoneInfo
Extension Methods

Properties

CurrentUtcOffset

Current offset to UTC. For example, +01:00 or -07:00.

[Column("current_utc_offset")]
[NotNull]
public string CurrentUtcOffset { get; set; }

Property Value

string

IsCurrentlyDst

True if currently observing daylight savings time.

[Column("is_currently_dst")]
[NotNull]
public bool IsCurrentlyDst { get; set; }

Property Value

bool

Name

Name of the time zone in Windows standard format. For example, Cen. Australia Standard Time or Central European Standard Time.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string