5 Replies Latest reply: Aug 2, 2013 4:40 AM by shagar mahabubjan RSS

    I want to convert the day into THAI language

    shagar mahabubjan

      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