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!

I want to convert the day into THAI language

shagar mahabubjanAug 2 2013 — edited Aug 2 2013

Hi All,

      I write a simple query using date conversion for THAI language. But the NLS_CALENDAR does not convert the DAY to Thai language but month and year shows in THAI only

Please give the date format for THAI language.

Query

select

DECODE (:p_language_id,

               'th', TO_CHAR (sysdate,

                              'DAY MONTH YYYY',

                              'NLS_CALENDAR=''THAI BUDDHA'''

                             ),

               TO_CHAR (sysdate, 'Day MONTHYYYY') ) dates from dual

Output:

FRIDAY    สิงหาคม    2556
This post has been answered by Oraclenewbie on Aug 2 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 30 2013
Added on Aug 2 2013
5 comments
2,731 views