Persian month abbreviation
haarseOct 6 2006 — edited Oct 16 2006Hi,
I wonder what is needed to retrieve Persian month abbreviation text.
Se example:
ALTER SESSION SET nls_calendar=GREGORIAN;
ALTER SESSION SET nls_language=american;
ALTER SESSION SET nls_territory=america;
SELECT to_char(to_date('2006-01-01', 'YYYY-MM-DD'), 'YYYY-MONTH-DD') FROM dual;
SELECT to_char(to_date('2006-01-01', 'YYYY-MM-DD'), 'YYYY-MON-DD') FROM dual;
ALTER SESSION SET nls_calendar=PERSIAN;
SELECT to_char(to_date('2006-01-01', 'YYYY-MM-DD'), 'YYYY-MONTH-DD') FROM dual;
SELECT to_char(to_date('2006-01-01', 'YYYY-MM-DD'), 'YYYY-MON-DD') FROM dual;
Why does MONTH work but not MON?
Regards
Håkan