Dear Community - when we last upgraded our APEX version (to 4.1), there was a trick (sadly now lost in the mists of time) whereby we could change the default date format used by SQL Commands. As far as I remember, it involved setting an NLS_DATE_FORMAT for APEX application 4500.
Although our database date format is set to DD-MON-RR, the newly-upgraded APEX 5.1.4 ignores this and uses MM/DD/YYYY as the default when running queries and scripts in SQL Commands.
Does anyone know how to set this back to DD-MON-RR?
I know that we can issue ALTER SESSION directives, and accept that we really should be applying date format strings to explicit date conversions (rather than expecting APEX to do implicit conversions based on NLS_DATE_FORMAT), but we had got very comfortable with DD-MON-RR and would like to have it back, if at all possible.
Many thanks for your help.
Regards,
John