Datetime values for reporting should always be written with the format yyyy-mm-dd hh:mi:ss

Current Situation

During report generation, the required data is provided in CSV files. Datetime values are written, which are expected by the generator in the form yyyy-mm-dd hh:mi:ss.

Database settings, e.g. for Oracle the setting for NLS_DATE_FORMAT can be responsible for the datetime values not being provided in the expected format.

Desired Behavior

The datetime values provided for report generation should always be written in the format yyyy-mm-dd hh:mi:ss.

Workaround for Oracle

Open the hibernate.cfg.xml file in <jetty_base>/resources/joc

Add this

<property name="hibernate.hikari.connectionInitSql">
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT=''YYYY-MM-DD HH24:MI:SS''';
END;
</property>

If you already have settings enabled with the property "hibernate.hikari.connectionInitSql" you can add them in the BEGIN/END block.