Compartir a través de

  • Artículo

DateTime2 Método

datetime2 is an extension of the existing datetime type. It has a large date range and large default fractional precision. It has a length of at least 19 positions.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Shared Function DateTime2 ( _
    scale As Integer _
) As DataType
'Uso
Dim scale As Integer
Dim returnValue As DataType

returnValue = DataType.DateTime2(scale)

public static DataType DateTime2(
    int scale
)

public:
static DataType^ DateTime2(
    int scale
)

static member DateTime2 : 
        scale:int -> DataType 

public static function DateTime2(
    scale : int
) : DataType

Parámetros

Valor devuelto

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

Comentarios

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

Ejemplos

Visual Basic

Dim dt As DataType
dt = New DataType(SqlDataType.DateTime2, 10)

PowerShell

$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::DateTime2, 10)