Home » SQL & PL/SQL » SQL & PL/SQL » sql stament with data functions
sql stament with data functions [message #18804] Thu, 14 February 2002 12:03 Go to next message
mary
Messages: 19
Registered: November 1999
Junior Member
select add_months(vLoadDate,1) into
vNextMonth
from dual;
result example vNextMonth = 30-APR-2002
I need to pass the variable of vNextMonth so I can
get 01-MAY-200 with format of 20020501

select to_char(to_date(vNextMonth,'yyyymmdd')+1)
into vHighValue
from dual;
What is wrong with this theory.. does not seem to work.. thanks for your help
Re: sql stament with data functions [message #18806 is a reply to message #18804] Thu, 14 February 2002 12:36 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
assuming vNextMonth is date variable...

select to_char(vNextMonth+1,'yyyymmdd') into vHighValue
from dual;
Previous Topic: how do i create a plsql type ..like table
Next Topic: Re: Dropping table in Oracle if they exist
Goto Forum:
  


Current Time: Fri Mar 29 10:12:39 CDT 2024