Skip to content
Related Articles

Related Articles

Improve Article


  • Last Updated : 19 May, 2021

In Microsoft SQL Server, SELECT DATE is used to get the data from the table related to the date, the default format of date is ‘YYYY-MM-DD’.


SELECT * FROM table_name

WHERE condition1, condition2,..;

Now we will execute queries on SELECT DATE on database student in detail step-by-step:

Step 1: Creating a database university:


Step 2: Using the database student:

USE student;

Step 3: Creating a table assignment_details with 5 columns:

In MSSQL there is data type DATE which accepts date.

CREATE TABLE assignment_details
    stu_id VARCHAR(20),
    stu_name VARCHAR(20),
    assn_name VARCHAR(20),
    due_date DATE,
    submission_date DATE

Step 4: Adding rows into table assignment_details :

INSERT INTO assignment_details VALUES

Step 5: Viewing the rows in the table:

SELECT * FROM assignment_details;

Query 1:  Display students who have submitted on ‘2021-04-20’.

SELECT * FROM assignment_details
WHERE submission_date='2021-04-20';

Query 2: Display students who have submitted after duedate.

SELECT * FROM assignment_details
WHERE due_date<submission_date;

Query 3: Display students who have submitted before duedate.

SELECT * FROM assignment_details
WHERE due_date>=submission_date;

Query 4: Display students who have submitted O.S assignment on time.

SELECT stu_id,stu_name,submission_date FROM assignment_details
WHERE assn_name='O.S' AND due_date>=submission_date;

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 :