Update Date Field in SQL Server

Last Updated : 10 Oct, 2021

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.

How to Perform Batch Updates in SQL Server

idevesh

Improve

Article Tags :

Similar Reads

SQL Server UPDATE JOIN

In the expansive realm of SQL Server, the UPDATE JOIN operation emerges as a potent tool for modifying data within tables by combining information from multiple sources. Unlike a traditional UPDATE statement that modifies a single table, UPDATE JOIN enables the modification of records based on condi

6 min read

CREATE TABLE in SQL Server

SQL Server provides a variety of data management tools such as querying, indexing, and transaction processing. It supports multiple programming languages and platforms, making it a versatile RDBMS for various applications. With its robust features and reliability, SQL Server is a popular choice for

4 min read

DATEADD() Function in SQL Server

DATEADD() function : This function in SQL Server is used to sum up a time or a date interval to a specified date, then returns the modified date. Features : This function is used to sum up a time or a date interval to a date specified. This function comes under Date Functions. This function accepts

3 min read

UPPER() function in SQL Server

The UPPER() function in SQL Server is a useful tool for converting all characters in a string to uppercase. This function is essential for ensuring uniform text formatting and for performing case-insensitive comparisons. In this article, We will learn about the UPPER() function in SQL Server by unde

3 min read

How to Perform Batch Updates in SQL Server

The Update statement is a SQL keyword to update data in the database. We can update all the rows in the database or some values with the help of conditions. The update is a SQL keyword, and it falls under Data Manipulation Language (DML), as the name suggests it is used to manipulate the data. Updat

5 min read

DELETE Statement in MS SQL Server

The DELETE statement in MS SQL Server deletes specified records from the table. SyntaxMS SQL Server DELETE statement syntax is: DELETE FROM table_name WHERE condition; Note: Always use the DELETE statement with WHERE clause. The WHERE clause specifies which record(s) need to be deleted. If you exclu

1 min read

PL/SQL INSERT ON DUPLICATE KEY UPDATE

In database management, maintaining data integrity while inserting new records is a common challenge. we may want to insert a new record, but if it already exists based on a unique key, we need to update the existing record. This process is known as "Upsert". In this article, we will explain how to

5 min read

SQL Server ALTER TABLE

In SQL Server, there are various commands to Add, Update, and Delete a Database Schema called DDL or Data Definition Language commands. A Table in a database is part of the database schema and the 'ALTER TABLE Moify Column' command is used to make changes to the database table column data type, colu

5 min read

SQL Server Describe Table

SQL Server is a widely used Relational Database Management System (RDBMS) that allows users to create and manage databases effectively. When working with databases in SQL Server it is essential to understand the schema of the tables present in the database. Describing a table means getting informati

4 min read

Dynamic SQL in SQL Server

In SQL Server, at times the SQL Queries need to be dynamic and not static, meaning the complete SQL query may be built dynamically at run time as a string using the user inputs and any specific application logic. This can be done in queries run from back-end applications or inside stored procedures.

6 min read