---

Search posts under SQL Server:

---

Check for valid date in SQL Server

How to check for valid date in SQL Server?

To check for a valid date, we can use IsValid function by passing the date string or a date value.

SELECT
ISDATE('15/16/2015') InValidDate,
ISDATE(GETDATE()) ValidDate