add days on a date field

[specv]

Hi,

I want to add ex : 10 days on a date and check with another date if the date + 10 days is < other date.

How can I do this (add days) ?

Thanks!

Phil

 

[carp]

I think it depends on the RDBMS you are using.
In Oracle, something like

SELECT something
FROM somewhere
WHERE (some_date + 10) < comparison_date;

would give you all of the rows where the date + 10 days is less than the comparison date.

 

[grega]

In Sybase (and probably MS SQL Server) you would use the dateadd function.

SELECT something
FROM somewhere
WHERE dateadd(dd, 10, some_date) < comparison_date

Greg.