Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Register
Login
SQL Server Transact Basic to Expert - Check if a given value is date or not using SQL
Karthikeyan Anbarasan
Jun 16, 2011
2.1
k
0
0
Blogs
WhatsApp
SQL Server Transact Basic to Expert - Check if a given value is date or not using SQL
This blog shows how to check if the given value is date or not using the ISDATE keyword in SQL query
Example:
SELECT ISDATE('1/1/20110')
The expected result would be 0 which means its not date value if a valid date is given it would return as 1
SQL Server Transact Basic to Expert - Check if a given value is date or not using SQL
Next Recommended Reading
SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query