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_date | Invalid_date |
---|---|
1 | 0 |