update sql server datetime field

Question

I already have data inserted in table with column of datetime named enddate. I want to update the all rows to have

 enddate = enddate - 1 minute.

How i can do this?

Thanks Samer

check this http://stackoverflow.com/questions/2309028/subtract-minute-from-datatime-in-sql-server-2005 — Nikson Kanti Paul, Jul 29 '12 at 09:30

score 2 · Answer 1 · edited Jul 29 '12 at 09:34

2

UPDATE tableName
SET enddate = DATEADD(minute, -1, enddate)

edited Jul 29 '12 at 09:34

Nikson Kanti Paul

answered Jul 29 '12 at 09:32

Glen Hughes

1 Answers1