DataType.SmallDateTime Property

Gets a data type that specifies the SmallDateTime definition used in the data type.

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

Syntax

'Declaration
Public Shared ReadOnly Property SmallDateTime As DataType 
    Get
'Usage
Dim value As DataType 

value = DataType.SmallDateTime

public static DataType SmallDateTime { get; }

public:
static property DataType^ SmallDateTime {
    DataType^ get ();
}

static member SmallDateTime : DataType

static function get SmallDateTime () : DataType

Property Value

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

Remarks

This property represents dates from 1900-01-01 through 2079-06-06. The date and time can be entered as in the example, "2008-05-20 12:35:29".

Examples

Visual Basic

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

PowerShell

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

See Also

Reference

DataType Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

smalldatetime (Transact-SQL)