Oracle nls_calendar thai buddha
How to use oracle nls_calendar thai buddha by sql. You can use sql at below
SELECT TO_CHAR(sysdate, ‘DD MON YYYY’, ‘nls_calendar=”Thai Buddha” nls_date_language = Thai’) DATE_CHAR FROM dual
SELECT TO_CHAR(SYSDATE, ‘DD-MM-YYYY’, ‘NLS_CALENDAR=”Thai Buddha”’) FROM DUAL
SELECT TO_CHAR(SYSDATE, ‘DD/MM/YYYY’, ‘NLS_CALENDAR=”THAI BUDDHA” NLS_DATE_LANGUAGE=THAI’) FROM DUAL