OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Date format

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date format [message #312617]

Wed, 09 April 2008 07:51

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;

Report message to a moderator

Re: Date format [message #312621 is a reply to message #312617]

Wed, 09 April 2008 08:07

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Okay. And your question is?

Report message to a moderator

Re: Date format [message #312622 is a reply to message #312621]

Wed, 09 April 2008 08:11

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

Report message to a moderator

Re: Date format [message #312641 is a reply to message #312622]

Wed, 09 April 2008 09:12

skooman
Messages: 913
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)

Report message to a moderator

Previous Topic:	Worksheet Link
Next Topic:	Error opening Data Model

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 04:53:27 CDT 2024