FreeSQL

Hello All,

In database LiveSQL V2 it is currently not possible to use ALTER SESSION to change NLS_DATE_FORMAT
in a script.

The ALTER SESSION statement runs without error, in NLS_SESSION_PARAMETERS we see the correct format set,
but, when running a SQL statement, we see a different format:

alter session set nls_date_format = 'YYYY-MM-DD'
/

Session altered.

select * from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT'
/

PARAMETER                 VALUE                          
------------------------- ------------------------------                 
NLS_DATE_FORMAT           YYYY-MM-DD        

select sysdate, trunc(sysdate)
from dual
/

SYSDATE                   TRUNC(SYSDATE)            
------------------------- ------------------------- 
07/05/2025, 07:16:37 PM   07/05/2025, 03:00:00 AM  

1 rows selected.

Also, for some reason, the default time for a truncated DATE appears as 03:00:00 AM instead of 00:00:00.

Thanks a lot in advance for looking into this problem.

Best Regards,
Iudith Mentzel