DataType.DateTimeOffset Method (Int32)

 

Returns values for year, month, day, valid time of day between 00:00:00 and 23:59:59:9999999 and offset, in hours, from UTC. It has a length of at least 25 positions.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public static DataType DateTimeOffset(
	int scale
)

Parameters

scale
Type: System.Int32

An Int32 representing the scale value.

Return Value

Type: Microsoft.SqlServer.Management.Smo.DataType

A DataType object value that specifies a DateTimeOffset definition in the data type.

The DateTimeOffset object constructor is initialized with the scale value that determines the precision of the DateTimeOffset object.

Visual Basic

Dim dt As DataType
dt = New DataType(SqlDataType.DateTimeOffset, 25)

PowerShell

$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::DateTimeOffset, 25)
Return to top
Show: