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.






      DECODE (:p_language_id,

                     'th', TO_CHAR (sysdate,

                                    'DAY MONTH YYYY',

                                    'NLS_CALENDAR=''THAI BUDDHA'''


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




      FRIDAY    สิงหาคม    2556