Xaisoft Xaisoft - 3 months ago 16
SQL Question

How do you update a DateTime field in T-SQL?

The following query does not update the datetime field:

update table
SET EndDate = '2009-05-25'
WHERE Id = 1


I also tried it with no dashes, but that does not work either.

Answer

When in doubt, be explicit about the data type conversion using CAST/CONVERT:

UPDATE TABLE
   SET EndDate = CAST('2009-05-25' AS DATETIME)
 WHERE Id = 1
Comments