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