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
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
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: help
Next Topic: Formatting problem in matrix group by report
Goto Forum:

Current Time: Mon Jun 26 00:30:48 CDT 2017

Total time taken to generate the page: 0.05476 seconds