Example
SELECT ISDATE('2017-08-25');Definition and Usage
The ISDATE() function checks an expression and returns 1 if it is a valid date, otherwise 0.
Syntax
ISDATE(
expression
)Parameter Values
| Parameter | Description |
|---|---|
| expression | Required. The expression to test |
Technical Details
| Return type: | int |
|---|---|
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |