var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DATE: Add Day ??
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 ..
You got it almost right (provided that DateDebut is of the DATE type):
Originally Posted by MadCat34
SELECT .... FROM ... WHERE WEEK(DateDebut + 1 day) BETWEEN .. AND ..
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"
Last edited by MadCat34; 12-05-05 at 09:40.