Date Object

[system]

Hi Gurus,

I need to create an object like this ( sysdate -2years) i.e I should get the result like this. If the sysdate is 10/19/2010 the result set should be 10/19/2008. Any help is appreciated.

Thanks,
Sukumar

---

reddy1868 (BOB member since 2010-01-28)

[system]

Hi,

This should work:

ADD_MONTHS(sysdate, -24)

---

Marek Chladny (BOB member since 2003-11-27)

[system]

create an object like…

add_months(sysdate,-24)

---

sati_sunil (BOB member since 2010-09-16)

[system]

Thanks, Marek!

---

reddy1868 (BOB member since 2010-01-28)