Hi,
Our AEP instances (Windows and RHEL) return date/times from our Oracle instance in the US date time format '05/03/14 04:00:14' e.g mm-dd-yy hh:mm:ss irrespective of the Oracle 'NLS_DATE_FORMAT' set at the database level (in our case NLS_DATE_FORMAT=DD-MON-RR)
This works well as its means date/times are always bought into AEP in a consistent way, irrespective of oracle settings and I can apply conversions via pilotscript if required.
Does anyone know if this is not always true. e.g can an AEP admin, at the AEP server level, alter the default date/time format that AEP uses to something else, so the US date format would not be the default returned. I can't see anything in the manuals or admin portal about how to change it so I guess its not configurable - can anyone confirm this?
I haven’t seem problems yet, but if different servers can have a different default I might need additional checks or altered SQL queries to specify a specific a return date.
Thanks
Joe