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

Report message to a moderator

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: 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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 08:52:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.