SqlFunctions.IsDate(String) Method

Definition

Namespace:

System.Data.Objects.SqlClient

Assembly:

System.Data.Entity.dll

Indicates whether the input value is a valid date or time.

public:
 static Nullable<int> IsDate(System::String ^ arg);

[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "ISDATE")]
public static int? IsDate (string arg);

[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "ISDATE")>]
static member IsDate : string -> Nullable<int>

Public Shared Function IsDate (arg As String) As Nullable(Of Integer)

Parameters

arg

String

The tested value.

Returns

Nullable<Int32>

1 if the input expression is a valid date or time value of datetime or smalldatetime data types; otherwise, 0.

Attributes

EdmFunctionAttribute

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see HOSTNAME (Transact-SQL).