Thu Oct 29 00:00:00 CST 2015 --> 2015/10/29
SELECT to_date(REPLACE('Thu Oct 29 00:00:00 CST 2015', 'CST', ''),'dy mon dd hh24:mi:ss yyyy','NLS_DATE_LANGUAGE = American') from dual
Thu Oct 29 00:00:00 CST 2015 --> 2015/10/29
SELECT to_date(REPLACE('Thu Oct 29 00:00:00 CST 2015', 'CST', ''),'dy mon dd hh24:mi:ss yyyy','NLS_DATE_LANGUAGE = American') from dual