Export (0) Print
Expand All

DataType.Time Method

Returns values for any valid time of day between 00:00:00 and 23:59:59:9999999. It has a length of at least eight positions and contains the time in hours, minutes, seconds and fractional seconds.

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

public static DataType Time(
	int scale
)

Parameters

scale
Type: Int32
An Int32 value which represents the scale (precision) of the result.

Return Value

Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType object value that specifies a Time definition and scale (precision) in the data type.

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

Visual Basic

Dim dt As DataType
dt = New DataType(SqlDataType.Time)

PowerShell

$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::Time)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft