databaseoracle-databasecalendarthai

Set up a Database with NLS_CALENDAR parameter as 'Thai Buddha'

I want to set up a database (Oraclev 12.1.0.2) with NLS_CALENDAR parameter as 'Thai Buddha', at the same time I need to keep character set as AL32UTF8.

When I do this at setting up NLS_CALENDAR parameter does not get changed at DB level. SELECT SYSDATE FROM DUAL returns Current date in A.D (year is 2016, in Thai it should be 2559)

But if I alter the session and set NLS_CALENDAR parameter as 'Thai Buddha' SELECT SYSDATE FROM DUAL returns date with year as 2559.

Are there any specific guidelines I should follow to get this done?, or are there any other parameters I should change?

Solution

  • In case anyone still looking for this, this can be done when setting up the database. Change following NLS_PARAMETERS 

    NLS_CALENDAR  = 'Thai Buddha'; 
NLS_DATE_LANGUAGE  = 'THAI'; 
NLS_DATE_FORMAT = 'DD_MM_RR';

    This will do. Cheers