to_char year conversion in different languages
463049Jun 18 2008 — edited Jun 19 2008I'm trying to make a to_char conversion that displays the date as words, but I need it to be displayed in different languages, for example:
SELECT TO_CHAR(SYSDATE, 'DAY MON DD YEAR','NLS_DATE_LANGUAGE=French')
FROM DUAL;
but this returns MERCREDI JUIN 18 TWO THOUSAND EIGHT, the problem here is that the year is not being translated, is there something I'm missing or do I need to make a function to achieve this?