Skip to content
Related Articles

Related Articles

SQL – SELECT DATE

Improve Article
Save Article
  • Last Updated : 19 May, 2021
Improve Article
Save Article

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’.

Syntax:

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:

CREATE DATABASE student;

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
('191021','SUJITH','DBMS','2021-04-21','2021-04-25'),
('191022','SUDEEP','DBMS','2021-04-21','2021-04-20'),
('191023','SARASWAT','O.S','2021-04-22','2021-04-24'),
('191024','SATWIK','C++','2021-04-23','2021-04-19'),
('191025','KOUSHIK','C++','2021-04-23','2021-04-21'),
('191026','ABHISHEK','O.S','2021-04-22','2021-04-20');

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;

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!