如何在hive中更改日期格式

I have one table in hive with column "dates"(String) and value as "5/29/2014 11:58:02 AM". I need to change the datatype from string to timestamp to process the data,I have created temporary table and trying to insert data from the original table:I have one table in hive with column "dates"(St