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:


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')
SQL Server ISDATE Function to. check Date Example

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.