update tablename set foo = 'bar', 
date = to_date( '03/03/2004', 'MM/DD/YYYY' )
where id = '1'