Oracle Qrery for get time and update time

// Select 

select to_char(COL_NAME,'MM/DD/YYYY HH:MI:SS AM') from TABLE_NAME

// Update
update TABLE_NAME set COL_NAME=to_date('2012-07-30 11:13:39','MM/DD/YYYY HH:MI:SS AM')