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;
Last Updated :
19 May, 2021
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...