Page History

...

The following trigger will do the trick by setting the right format every time the db user (in this example 'ofbiz') will connect to the db: this user must be the one you set in the entityengine.xml file:

create or replace TRIGGER ON_CONNECT AFTER LOGON ON DATABASE

...

 DECLARE

...

 guser varchar2(30);

...

 begin

...

 SELECT sys_context('USERENV','SESSION_USER') into guser FROM dual;

...

 

if guser='ofbiz' THEN

...

 EXECUTE IMMEDIATE 'alter session set nls_timestamp_format = ''YYYY-MM-DD HH24:MI:SS.FF''';

...

 end

...

 if

...

 ;

...

end;

Thanks to Giorgio Tomaselli for this script.

This solution is valid for the "ORA-01830: date format picture ends before converting entire input string" error too.

How to set the format of Dates

...