How to increment DateTime field in SQL Server 2005 by a month?

Question

I have a DateTime field in SQL Server for some products expiration (ExpirationDate). I need to increment all the items manually, and set their expiration a month later than the date stored in the field currently. How can I do that?

Answer 1

I don't have SQL Server on my computer, so I cannot test, but what about using DATEADD, a bit like this :

update your_table set your_field = DATEADD(month, 1, your_field)

Answer 2

UPDATE Products SET ExpirationDate=DATEADD(month,1,ExpirationDate) WHERE Type='Cheese'