How to convert the JSON date with to_date function How to convert the specific string Aug 6, 2018 3:17:11 PM with the function to_date?

That string is a result of a Java parsing mechanism for JSON. I would like to be able to recover it directly from oracle.


  My real problem is much more comprehensive that looks to be. It evolves the APEX_JSON usage, but it is not the question.
select to_date('Aug 6, 2018 3:17:11 PM', 'MON DD, YYYY HH:MI:SS PM') from dual;

TO_DATE('AUG6,20183
-------------------
2018-08-06 15:17:11


Datetime Format Models