Home » Developer & Programmer » Reports & Discoverer » Date format
Date format [message #312617] Wed, 09 April 2008 07:51 Go to next message
joeslee
Messages: 18
Registered: February 2008
Location: Bangalore
Junior Member

select &P_DATE_STR := 'From '||TO_char(TO_DATE(:p_eff_dt,'DD-MON-YY'),'Month DD, YYYY')||' to '||
TO_char(sysdate,'Month DD, YYYY') from dual;
Re: Date format [message #312621 is a reply to message #312617] Wed, 09 April 2008 08:07 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Okay. And your question is?
Re: Date format [message #312622 is a reply to message #312621] Wed, 09 April 2008 08:11 Go to previous messageGo to next message
joeslee
Messages: 18
Registered: February 2008
Location: Bangalore
Junior Member

My question is to display the start and end date of my previous quarter..

For example it should display the quarter from Jan 1st to March 31st...This is the current quarter
Re: Date format [message #312641 is a reply to message #312622] Wed, 09 April 2008 09:12 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
And what would the input be? Like one date (sysdate?) and then display two values being the start and enddate of the previous quarter?

What do you need this for BTW? (just curious)
Previous Topic: Worksheet Link
Next Topic: Error opening Data Model
Goto Forum:
  


Current Time: Thu Dec 08 02:09:24 CST 2016

Total time taken to generate the page: 0.06363 seconds