| Subject: | Oracle MON specifier returns the wrong case |
When using the the "MON" format specifier, the month is returned with Init Caps. This should only happen with the "Mon" specifier. E.g.
select to_char(sysdate, 'DD-MON-YYYY') from dual;
24-JUN-2016
select to_char(sysdate, 'DD-Mon-YYYY') from dual;
24-Jun-2016