T-SQL Tutorial

T-SQL ISDATE Date Function


Check if the expression is a valid date. Return 1 for valid date and 0 for invalid date.

ISDATE() Syntax:

ISDATE(expression)

ISDATE Example:

SELECT ISDATE('01/28/2014') as Valid_date,
ISDATE('21/21/2014') as Invalid_date;

Valid_dateInvalid_date
10