OraFAQ Forum: Reports & Discoverer » In date column date and month are printing (11-may) but year is not printing in the report

Home » Developer & Programmer » Reports & Discoverer » In date column date and month are printing (11-may) but year is not printing in the report (Oracle business intelligence discoverer 11g)

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

In date column date and month are printing (11-may) but year is not printing in the report [message #686148]

Thu, 23 June 2022 08:33

pa23van876
Messages: 2
Registered: June 2022

Junior Member

Hi All,

In one of the requested date column date and month are printing (11-may) but year is not printing in the report, but
other date columns are also there in that column dates,month,year is printing fine like (11-may-2022), only in one of the requested date column it is not printing the year. Any settings needs to be done in oracle discoverer 11g??.

please anyone provide the solution

Thanks in advance.

Report message to a moderator

Re: In date column date and month are printing (11-may) but year is not printing in the report [message #686152 is a reply to message #686148]

Thu, 23 June 2022 14:19

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use Discoverer, but - in Reports Builder, you'd set format model for that column in order to display its value the way you want it. In your case, that would be dd-mon-yyyy.

On the other hand, if the "source" of Discoverer's output is a query, then check whether someone already set that column's date format using the TO_CHAR function, e.g.

select ename, job, sal, 
  to_char(hiredate, 'dd-mon') as hiredate       --> this
from emp

Report message to a moderator

Re: In date column date and month are printing (11-may) but year is not printing in the report [message #686155 is a reply to message #686152]

Mon, 27 June 2022 03:41

pa23van876
Messages: 2
Registered: June 2022

Junior Member

Thanks for that @Liitlefoot

but other than to_char any settings that we can do in Discoverer 11g only ?

Report message to a moderator

Re: In date column date and month are printing (11-may) but year is not printing in the report [message #686156 is a reply to message #686155]

Mon, 27 June 2022 11:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As I said, I don't use Discoverer.

So, if you checked two options I mentioned:
- whether it (the Discoverer) lets you specify format model and
- tried TO_CHAR
but none of these helped, I'm afraid I don't have any other ideas.

I remotely remember that we (OraFAQ) have had member who knows that tool, but I don't remember who it was so ... I can't really suggest that you should wait a little bit longer for someone else to reply, because such a chance is rather poor (at least, I think so). Perhaps you should try with OTN forums, here: https://community.oracle.com/tech/developers/discussion/116081/queries-on-discoverer-oracle-reports

Report message to a moderator

Previous Topic:	REP-3335 Error
Next Topic:	Oracle 12c report call showing Oracle SSO in blank page and not Showing Report.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 12:53:56 CST 2024