Loading lesson path
Concept visual
Start at both ends
Check if the expression is a valid date:
SELECT ISDATE('2017-08-25');The ISDATE() function checks an expression and returns 1 if it is a valid date, otherwise
0.
expression )
Required. The expression to test
int
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Check if the expression is a valid date:
SELECT ISDATE('2017');Check if the expression is a valid date:
SELECT ISDATE('Hello world!');❮ SQL Server Functions