I have been asked to display the dates in a BI Publisher extract in the following format:
DD-Mon-YY - I.e. 20-Jul-19
I thought it was just a matter of using a TO_CHAR and applying the date mask. To my surprise, I kept on seeing the month being displayed in numeric format.
The solution was to convert the date to char by adding the NLS_DATE_LANGUAGE parameter.
I.e. to_char(START_DATE,'DD-Mon-YY','nls_date_language=American')
Result:
