Skip to Main Content

Database Software

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!

Persian Day Name on Persian Calendar Display Hijr Day Name

633850May 20 2008 — edited Jun 13 2008
Hi all,

I was working on Persian Calendar for Oracle Form. May I have the correct NLS setup in order for me to display a correct Persian Day Name on persian Calendar. These are the current setup that I set on my environment :

NLS_LANG=ARABIC_SAUDI ARABIA.UTF8
NLS_CALENDAR=PERSIAN

With these setup, I manage to display correct month name and year on Persian Calendar. Unfortunately, the day name is incorrect as it show Hijr day name as below:
al-jum'ah (friday),
as-sabt(saturday),
al-ahad(sunday),
al-ithniyn(monday),
ath-thulatha(tuesday),
al-arba'aa(wednesday),
al-khamees(thursday).

How do i can get it to display Persian day name on the calendar like below:
jomeh(friday),
shanbe(saturday),
yekshanbe(sunday),
doshanbe(monday),
seshanbe(tuesday),
chaharshanbe(wednesday),
panjshanbe(thursday).

The reason why I choose ARABIC language and UTF8 characterset is because Oracle do not yet have the PERSIAN language value supported so far. Is it true?

All kind of help are highly appreciated ...

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2008
Added on May 20 2008
13 comments
5,530 views