The UPDATE statement in SQL is used to update the data of an existing table in the database. We can update single columns as well as multiple columns using the UPDATE statements as per our requirement. With this article, we will learn how to Update the Date Field in SQL Server. In this article, we will be making use of the Microsoft SQL Server as our database.
So, we will create a database first:
Step 1: Create Database
CREATE DATABASE GFG
Step 2: Use Database
Step 3: Create a table
Create a table (TimeTable) in the database to store the data.
CREATE TABLE TimeTable(
SubjectDate datetime NOT NULL ,
SubjectName char (10)
Step 4: Insert the data into the database
/* Data Inserted for a full week dates*/
INSERT INTO TimeTable (SubjectDate , SubjectName) VALUES ('01/10/2021','DSA')
INSERT INTO TimeTable (SubjectDate , SubjectName) VALUES ('02/10/2021','CD')
INSERT INTO TimeTable (SubjectDate , SubjectName) VALUES ('03/10/2021','DBMS')
INSERT INTO TimeTable (SubjectDate , SubjectName) VALUES ('04/10/2021','OS')
Step 5: Now change the data of DateTime
In the below query, the SET statement is used to set new values to the particular column, and the WHERE clause is used to select the rows for which the columns are needed to be updated. If we have not used the WHERE clause then the columns in all the rows will be updated. So the WHERE clause is used to choose the particular rows.
SET SubjectDate = '05/10/2021'
WHERE SubjectName = 'DSA'
As we can see subject date has been changed.
Unlock the Power of Placement Preparation!
Feeling lost in OS, DBMS, CN, SQL, and DSA chaos? Our Complete Interview Preparation
Course is the ultimate guide to conquer placements. Trusted by over 100,000+ geeks, this course is your roadmap to interview triumph.
Ready to dive in? Explore our Free Demo Content and join our Complete Interview Preparation