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
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