Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date format in prompt OBI 10g

809448May 24 2012 — edited May 30 2012
HI Experts,

I have requirement for date format mm/dd/yyyy need to change dd/mm/yyyy . I used the following the query but giving error:

EVALUATE('TO_CHAR(%1,%2)' ,"SI - Creations & Modifications
Dim"."Première Date de Valeur" , 'DD-MM-YYYY')


nQSError: 10058] A general error has occurred. [nQSError: 22027] Union
of non-compatible types. (HY000)
SQL Issued: SELECT EVALUATE('TO_CHAR(%1,%2)' ,"SI - Creations &
Modifications Dim"."Première Date de Valeur" , 'DD-MM-YYYY') FROM SI



Regards
Birudu Gopal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2012
Added on May 24 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #date, #obiee
12 comments
2,001 views