Q. How does APP_DATE_TIME_FORMAT get defaulted when NULL?
Scenario
I have an application with these default APEX globalization settings…
The inline help next to Application Date Time Format says
If this attribute value is not specified, then a reference to APP_DATE_TIME_FORMAT will return the NLS database session date format and the NLS time format.
Presumably the ‘_NLS time format_’ means the NLS_TIME_FORMAT parameter, which in my case is HH24.MI.SSXFF.
Due to the XFF portion, this HH24.MI.SSXFF is a timestamp format mask and cannot be to_dated with SYSDATE (unless we provide SYSTIMESTAMP) i.e
However APEX is defaulting the APP_DATE_TIME_FORMAT to DS HH24.MI.SS
I understand that the DS part is now represents either the value of APP_NLS_DATE_FORMAT or NLS_DATE_FORMAT - since these are both now identical. i.e the documentation states that APEX does this i.e
This date format [Application Date Format] is used to alter the NLS_DATE_FORMAT database session
However the HH24.MI.SS kind of resembles the NLS_TIME_FORMAT (i.e HH24.MI.SSXFF) however APEX has either (1) Stripped off the XFF (timestamp specific format mask portion) or (2) the documentation is misleading, and its taking it from another source.
Basically, the question is: How does APP_DATE_TIME_FORMAT get defaulted when NULL?
Cheers
MM