Oracle nls_calendar thai buddha

Posted on by

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

Posted in SQL.