SQL> create table t(name varchar2(25), arrival DATE);

Table created.

SQL> insert into t values('&name',to_Date('&arrival','HH24:MI'));
Enter value for name: Peter
Enter value for arrival: 12:23
old   1: insert into t values('&name',to_Date('&arrival','HH24:MI'))
new   1: insert into t values('Peter',to_Date('12:23','HH24:MI'))

1 row created.

SQL> /
Enter value for name: Frank
Enter value for arrival: 12:55
old   1: insert into t values('&name',to_Date('&arrival','HH24:MI'))
new   1: insert into t values('Frank',to_Date('12:55','HH24:MI'))

1 row created.

SQL> /
Enter value for name: Jenny
Enter value for arrival: 23:58
old   1: insert into t values('&name',to_Date('&arrival','HH24:MI'))
new   1: insert into t values('Jenny',to_Date('23:58','HH24:MI'))

1 row created.

SQL> /
Enter value for name: John
Enter value for arrival: 9:12
old   1: insert into t values('&name',to_Date('&arrival','HH24:MI'))
new   1: insert into t values('John',to_Date('9:12','HH24:MI'))

1 row created.

SQL> Commit;

Commit complete.

SQL> Select * From t;

NAME                      ARRIVAL
------------------------- ---------
Peter                     01-NOV-03
Frank                     01-NOV-03
Jenny                     01-NOV-03
John                      01-NOV-03

SQL> Select Name
  2       , to_char(arrival,'HH24:MI') arrival
  3    From t;

NAME                      ARRIV
------------------------- -----
Peter                     12:23
Frank                     12:55
Jenny                     23:58
John                      09:12

SQL> Alter session set nls_date_format='HH24:MI'
  2  /

Session altered.

SQL> Select * From t;

NAME                      ARRIV
------------------------- -----
Peter                     12:23
Frank                     12:55
Jenny                     23:58
John                      09:12

SQL>