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!

Change format of date in Answers/RPD

OBDOct 21 2013 — edited Oct 23 2013

Hello All,

We have a requirement to change the date column format from 'M/DD/YYYY' to 'DD-MMM-YYYY' in answers where ever the column n is been used. But is should not be changed in DB.

I have tried to use CAST function and Evaluate function.

If I change data tyoe of date column to CHAR by CAST function it's displaying as 'DD-MMM-YY', how can I change this to 'DD-MMM-YYYY'.

I have tried multiple syntax's by evaluate function as by gong through  blogs/forums, but for some reason the syntax is not working..

Please suggest for the solution. Thanks.

Regards,

OBD

OBIA consltant
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2013
Added on Oct 21 2013
#answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
8 comments
1,176 views