The SQL ISDATE is one of the Date and Time Functions, which will check whether the given expression is a Date or not. If the specified expression is Date, Time, or Datetime, then it will return 1. Otherwise, 0. The basic syntax of the ISDATE is as shown below:
ISDATE(Expression)
The return value of this function always depends upon the SET DATEFORMAT and SET LANGUAGE statements. If the given expression is datetime2 then it will return 0
SQL Server ISDATE Function Example
In this DateTime example, we will show you how to use IS DATE in Server to change the time zone (offset value)
-- Using Date
SELECT ISDATE('2018-01-02')
-- Only Time Value
SELECT ISDATE('15:02:13.950')
-- Using Date and time
SELECT ISDATE('2018/01/02 15:02:13.950')
-- Try on datetime2 datatype value
SELECT ISDATE('2018/01/02 12:03:28.0000000')
