Home » Developer & Programmer » Forms » ADD years
ADD years [message #80247] Thu, 29 August 2002 05:24 Go to next message
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
Re: ADD years [message #80248 is a reply to message #80247] Thu, 29 August 2002 06:22 Go to previous messageGo to next message
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);
Re: ADD years [message #80254 is a reply to message #80248] Fri, 30 August 2002 04:46 Go to previous message
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: Sat Mar 02 10:44:34 CST 2024