SQL UPDATE DATE

Last Updated : 17 Mar 2025

How to update a date and time field in SQL?

If you want to update a date & time field in SQL, you should use the following query.

let's see the syntax of sql update date.

UPDATE table 
SET Column_Name = 'YYYY-MM-DD HH:MM:SS'
WHERE Id = value

Let us check this by an example:

Firstly we take a table in which we want to update date and time fields.

If you want to change the first row which id is 1 then you should write the following syntax:

UPDATE table 
SET EndDate = '2014-03-16 00:00:00.000' 
WHERE Id = 1 

Note: you should always remember that SQL must attach default 00:00:00.000 automatically.

This query will change the date and time field of the first row in that above assumed table.

Next TopicSQL DELETE

<<prev next>>

We deliver comprehensive tutorials, interview question-answers, MCQs, study materials on leading programming languages and web technologies like Data Science, MEAN/MERN full stack development, Python, Java, C++, C, HTML, React, Angular, PHP and much more to support your learning and career growth.