select to_date('Fri Jul 04 16:50:48 CST 2003', 'Dy Mon DD HH24:MI:SS "CST" YYYY', 'nls_date_language=english') from dual;