Update Date Field in SQL Server

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

Query:

CREATE DATABASE GFG

Step 2: Use Database

Query:

USE GFG

Step 3: Create a table

Create a table (TimeTable) in the database to store the data.

Query:

CREATE TABLE TimeTable(
 SubjectDate datetime NOT NULL ,
 SubjectName char (10)
)

Step 4: Insert the data into the database 

Query:

/* 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.

Query:

UPDATE TimeTable   
SET SubjectDate = '05/10/2021'   
WHERE SubjectName = 'DSA'   

Output:

As we can see subject date has been changed.