Skip to Main Content
Forums

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!

Converting date in french format

User414920Sep 9 2011 — edited Sep 9 2011
Hi All,

Hi All,


Please let me know if you have any idea



I am converting the date to French /infact multi lang

select to_char(sysdate,'Fmddth Month, yyyy','NLS_DATE_LANGUAGE =FRENCH') from dual

so this is giving me "8th Septembre, 2011"



but what i want is "8er Septembre, 2011" instead of "th" i need "er"

Thanks & Regards,
Dhana
This post has been answered by Sven W. on Sep 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2011
Added on Sep 9 2011
4 comments
4,217 views