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

Views: 12199 | Post Order: 75