OraFAQ Forum: Forms » ADD years

Home » Developer & Programmer » Forms » ADD years

Thu, 29 August 2002 05:24

vv
Messages: 5
Registered: May 2002

Junior Member

guys I need to add 3 years to '31-MAR-2000'.

Any water tight solutions pleeze.

Cheers folks.
n

Thu, 29 August 2002 06:22

Julie Toft
Messages: 9
Registered: August 2002

Junior Member

I'd use the plsql date function add_months.
v_newdate := ADD_MONTHS(v_olddate, 36);

Fri, 30 August 2002 04:46

THANX JUlIE
Messages: 1
Registered: August 2002

Junior Member

thx.

Previous Topic:	Menu Errors
Next Topic:	Re: checking for file on system????????

Goto Forum:

]

Current Time: Fri Apr 26 09:32:52 CDT 2024