Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to_char year conversion in different languages

463049Jun 18 2008 — edited Jun 19 2008
I'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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2008
Added on Jun 18 2008
2 comments
513 views