SqlServerDbFunctionsExtensions.AtTimeZone Method

Definition

Namespace:

Microsoft.EntityFrameworkCore

Assembly:

Microsoft.EntityFrameworkCore.SqlServer.dll

Package:

Microsoft.EntityFrameworkCore.SqlServer v8.0.0

Overloads

AtTimeZone(DbFunctions, DateTime, String)	Converts dateTime to the corresponding datetimeoffset in the target timeZone. Corresponds to the SQL Server AT TIME ZONE construct.
AtTimeZone(DbFunctions, DateTimeOffset, String)	Converts dateTimeOffset to the time zone specified by timeZone. Corresponds to the SQL Server AT TIME ZONE construct.

AtTimeZone(DbFunctions, DateTime, String)

Converts dateTime to the corresponding datetimeoffset in the target timeZone. Corresponds to the SQL Server AT TIME ZONE construct.

public static DateTimeOffset AtTimeZone (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTime dateTime, string timeZone);

static member AtTimeZone : Microsoft.EntityFrameworkCore.DbFunctions * DateTime * string -> DateTimeOffset

<Extension()>
Public Function AtTimeZone (_ As DbFunctions, dateTime As DateTime, timeZone As String) As DateTimeOffset

Parameters

_

DbFunctions

The DbFunctions instance.

dateTime

DateTime

The value to convert to datetimeoffset.

timeZone

String

A valid SQL Server time zone ID.

Returns

DateTimeOffset

The datetimeoffset resulting from the conversion.

Remarks

Note that the Kind of dateTime is not taken into account when performing the conversion; the offset for the provided time zone is simply applied as-is.

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

AtTimeZone(DbFunctions, DateTimeOffset, String)

Converts dateTimeOffset to the time zone specified by timeZone. Corresponds to the SQL Server AT TIME ZONE construct.

public static DateTimeOffset AtTimeZone (this Microsoft.EntityFrameworkCore.DbFunctions _, DateTimeOffset dateTimeOffset, string timeZone);

static member AtTimeZone : Microsoft.EntityFrameworkCore.DbFunctions * DateTimeOffset * string -> DateTimeOffset

<Extension()>
Public Function AtTimeZone (_ As DbFunctions, dateTimeOffset As DateTimeOffset, timeZone As String) As DateTimeOffset

Parameters

_

DbFunctions

The DbFunctions instance.

dateTimeOffset

DateTimeOffset

The value on which to perform the time zone conversion.

timeZone

String

A valid SQL Server time zone ID.

Returns

DateTimeOffset

The datetimeoffset resulting from the conversion.

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.