add months to particular date

treddy123 · #1 (**permalink**) 03-31-04, 03:00

Hello All:

Is there any equivalent of add_months in oracle, that can be used in DB2.

Tank · #2 (**permalink**) 03-31-04, 04:00

Hi Treddy

I wouldn't know - I use db2.

But if you specify what you want to do and
on which platform - someone will surely be
able to help you!

treddy123 · #3 (**permalink**) 03-31-04, 04:06

In oracle to add 2 months to the sysdate we execute the below statement.

SQL> select add_months(sysdate, 2), sysdate from dual;

ADD_MONTH SYSDATE
--------- ---------
31-MAY-04 31-MAR-04

I want a similar function in DB2.

sathyaram_s · #4 (**permalink**) 03-31-04, 04:52

CURRENT DATE + 2 MONTHS should give you ...

SQL Reference is the manual you may want for SQL functions ... Please always take time to search in this manual before posting ... You may save considerable amount of your time and others' time ...

Cheers
Sathyaram

Quote:

Originally posted by treddy123
In oracle to add 2 months to the sysdate we execute the below statement.

SQL> select add_months(sysdate, 2), sysdate from dual;

ADD_MONTH SYSDATE
--------- ---------
31-MAY-04 31-MAR-04

I want a similar function in DB2.

Internet Services

Web Development

Digital Marketing

Consumer Tech