DATE: Add Day ??

MadCat34 · #1 (**permalink**) 12-05-05, 09:28

Hello everybody!
First, I'm French (sorry for my english ^^).

I'm a newbie on IBM DB2.
I'd like to know if there is a function to add day on a date.
For exemple (DateADD --> MS SQL Server)
to do something like that:

SELECT .... FROM ... WHERE WEEK(DateDebut + 1day) BETWEEN .. AND ..

Thank you

n_i · #2 (**permalink**) 12-05-05, 09:33

Quote:

Originally Posted by MadCat34

to do something like that:

SELECT .... FROM ... WHERE WEEK(DateDebut + 1day) BETWEEN .. AND ..

You got it almost right (provided that DateDebut is of the DATE type):

Code:

SELECT .... FROM ... WHERE WEEK(DateDebut + 1 day) BETWEEN .. AND ..

MadCat34 · #3 (**permalink**) 12-05-05, 09:35

Well , DateDebut is like that: '2005-10-01 12:00:25.000000'
So, yes, i think it's Date Type

PS: Thanks! It's working ^^
I thought there was a function do add...and i didn't know the "Date + x day"

Internet Services

Web Development

Digital Marketing

Consumer Tech