Hi,
for a client in Thailand I have to create interactive reports containing some date columns (format dd-mon-yyyy).
The month is shown correctly in Thai, in the report and in the filter of the date column, but the proposed year is 2023 and if I select “Today” in the calendar I get 27.07.2023. I want to get the THAI year which is 543 years ahead of the Western or Gregorian calendar year.
In the APEX Security Attributes/Database Session I set
execute immediate 'alter session set nls\_language=''THAI''';
execute immediate 'alter session set NLS\_TERRITORY=''THAILAND''';
execute immediate 'alter session set nls\_calendar=''Thai Buddha''';
execute immediate 'alter session set nls\_date\_format=''DD/MM/YYYY''';
execute immediate 'alter session set nls\_date\_language=''Thai''';
But it doesn't work for the year.
I use APEX 23.1.
Thank's for a tip.
Kirsten