How to convert the JSON date with to_date function

Question

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.

Answer 1

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