You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to I achieve DD-MON-RRRR in output of BI publisher report for a date

edited Jun 23, 2020 12:50PM in Reporting and Analytics for HCM 3 comments

Summary

How to I achieve DD-MON-RRRR in output of BI publisher report for a date

Content

Hi,

I transform my date column in the required format using

TO_CHAR(effective_start_date,'DD-MON-RRRR').

But result is not as per expectation.

It shows as 23-06-2020 and expectation is 23-Jun-2020.

What could be the reason for this?

Any help is appreciated

Regards
Rashmi

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!