Home » Developer & Programmer » Reports & Discoverer » date to quarter help (disc 10.1.2)
date to quarter help [message #335751] Wed, 23 July 2008 09:47 Go to next message
Messages: 235
Registered: December 2007
Location: USA
Karma: 0
Senior Member
Hi All
I 'm generating a report where in i have to diplay the 2 digits year and quarter and i'm using the following calculation in the discoverer plus and i'm not sure why its not working, any kind of help or advice will be great.


Thank You
Re: date to quarter help [message #335887 is a reply to message #335751] Thu, 24 July 2008 01:43 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Karma: 0
Senior Member
You mean:

to_char(date_column,'yyyy') ||'0'||to_char(date_column,'q')

By the way, don't use yy, use yyyy (remember the Y2K issue?)

[Updated on: Thu, 24 July 2008 01:43]

Report message to a moderator

Previous Topic: PRINT JOB Parameter Usage in 9i Reports
Next Topic: how to pass parameter to report
Goto Forum:

Current Time: Tue Aug 22 12:00:14 CDT 2017

Total time taken to generate the page: 0.11682 seconds