How to convert the JSON date with to_date function
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