共用方式為

DataType.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.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Shared Function DateTime2 ( _
    scale As Integer _
) As DataType
'用途
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

參數

  • scale
    型別：System.Int32
    An Int32 value which represents the scale (precision) of the result.

傳回值

型別：Microsoft.SqlServer.Management.Smo.DataType
A DataType object value that specifies a DateTime2 definition in the data type.

備註

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

範例

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)

請參閱

參考

DataType 類別

Microsoft.SqlServer.Management.Smo 命名空間