Adding Days to Dates in SQL Server

[Mike Squires]

Is it possible to easily add say 30 days to an existing date in table? In
this case not the system date. I have a record which has the date 01-01-2000
and I want to add 30 to it, so the date is 31-01-2000.

Is this possible in SQL?

[Mike Squires]

[Thomas R. Hummel]

Check out the DATEADD function in the Transact SQL help file.

-Tom.

In article <96693688...@ernani.logica.co.uk>,

Sent via Deja.com http://www.deja.com/
Before you buy.

[markdm...@my-deja.com]

And, even easier than that, because you are dealing with days, you can
do a

[date_column] + 30

and it will add 30 days to it.

In article <8nu7fq$m3c$1...@nnrp1.deja.com>,

[BPMargolin]

Though please note that this will work only in SQL Server 7.0. Date arithmetic
does not work in versions of SQL Server before 7.0.

---------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.

<markdm...@my-deja.com> wrote in message news:8nu9nt$p2k$1...@nnrp1.deja.com...