Méthode DateTime2
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.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Shared Function DateTime2 ( _
scale As Integer _
) As DataType
'Utilisation
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
Paramètres
- scale
Type : System. . :: . .Int32
An Int32 value which represents the scale (precision) of the result.
Valeur de retour
Type : Microsoft.SqlServer.Management.Smo. . :: . .DataType
A DataType object value that specifies a DateTime2 definition in the data type.
Notes
The returned DateTime2 object constructor is initialized with the scale value that determines the precision of the DateTime2 object.
Exemples
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)