Skip to content
Related Articles

Related Articles

Improve Article

SQL Query to Check Given Format of a Date

  • Last Updated : 11 Aug, 2021
Geek Week

Here, we are going to see how to find the SQL Query to check whether the date passed to query is the date of the given format or not. In this article, we will be making use of the Microsoft SQL Server as our database.

Here, we will first create a database named “geeks” then we will create a table “department” in that database. After, that we will execute our query on that table.

Creating Database:

CREATE DATABASE geeks;

Using the Database:

USE geeks;

Table Definition:



We have the following table named as department in our geeks database.

CREATE TABLE department
(
    ID int,
    SALARY int,
    NAME Varchar(20),
    JoinDate datetime 
);

Adding value into the table:

INSERT INTO department VALUES (1, 34000, 'Neha', '09-24-2013')
INSERT INTO department VALUES (2, 33000, 'Hema', '02-02-2015')
INSERT INTO department VALUES (3, 36000, 'Jaya', '09-09-2017')
INSERT INTO department VALUES (4, 35000, 'Priya', '05-18-2018')
INSERT INTO department VALUES (5, 34000, 'Ketan', '02-25-2019')

To verify the contents of the table use the following SQL query:

SELECT * FROM department;

Checking whether the date passed to query is the date of the given format or not:

SQL has IsDate() function which is used to check the passed value is date or not of specified format, it returns 1(true) when the specified value is date otherwise it return 0(false).

Syntax:

SELECT ISDATE(‘Date’) AS “Format”;

OR

SELECT *, ISDATE(‘ColumnName’) AS “Format” FROM TABLENAME ;

Example: 

SELECT TOP 1000 [ID]
     ,[SALARY]
     ,[NAME]
     ,[JoinDate], ISDATE(JoinDate) as Format 
 FROM [department]

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

My Personal Notes arrow_drop_up
Recommended Articles
Page :