TO_DATE

update TABLE
set FIELD = to_date('04/05/2010 16:55:00','mm/dd/yyyy hh24:mi:ss')
where ID = '24';

commit;

=================================================

select ID, to_char(FIELD, 'HH24:MI:SS') as "formated_date" from TABLE;