• Article

DataType.DateTimeOffset Method

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)

Syntax

'Declaration
Public Shared Function DateTimeOffset ( _
    scale As Integer _
) As DataType
'Usage
Dim scale As Integer
Dim returnValue As DataType

returnValue = DataType.DateTimeOffset(scale)

public static DataType DateTimeOffset(
    int scale
)

public:
static DataType^ DateTimeOffset(
    int scale
)

static member DateTimeOffset : 
        scale:int -> DataType 

public static function DateTimeOffset(
    scale : int
) : DataType

Parameters

Return Value

Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType object value that specifies a DateTimeOffset definition in the data type.

Remarks

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

Examples

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)