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
aarti81
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.

TO_CHAR(d,'yy'||'0'||d,'q')


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
skooman
Messages: 912
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 Dec 05 15:17:06 CST 2016

Total time taken to generate the page: 0.05118 seconds