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 |