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;
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;