SQL UPDATE DATE With Example

UPDATE DATE statement:

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


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 

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