• Article

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)

Syntax

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

returnValue = DataType.Time(scale)

public static DataType Time(
    int scale
)

public:
static DataType^ Time(
    int scale
)

static member Time : 
        scale:int -> DataType 

public static function Time(
    scale : int
) : DataType

Parameters

  • scale
    Type: System.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.

Remarks

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

Examples

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)