G'day team,
I've been testing our applications on a 12c APEX 5 environment and I've encountered an issue regarding date conversions. I'm not sure yet if this is a 12c or APEX 5 thing, as we are coming from 11g with 4.2. (Next week I can check this on APEX 5 against 11g)
I was under the impression that when working with dates in APEX you could convert the bind variable without supplying the date format and it would use the relevant format in the conversion.
to_date(:P1_DATE_PICKER)
I've found that now I need to be explicit with the date format, as to avoid ORA-01843.
to_date (:P1_DATE_PICKER, :APP_NLS_DATE_FORMAT)
I'm leaning to this being a 12c thing because I've just encountered this when converting a column in a view, ie
select to_date(c001) from apex_collections
This returned ORA-01843: not a valid month, but adding a date format fixed the problem.
I would appreciate people's input on this, cheers,
Scott.