create table 
table_1 (date_1 date);

insert into table_1 values (to_date('23:21:21','HH24:MI:SS'));

SQL> insert into t3 values(To_date('10:25','HH24:MI'));

1 row created.

SQL> alter session set nls_date_format='HH24:Mi:SS';

Session altered.

SQL> select * from t3;

DAT
--------
10:25:00

SQL> insert into t3 (dat) values(to_date('10:10:10','HH24:MI:SS'));

1 row created.

SQL> select * from t3;

DAT
--------
10:25:00
10:10:10

SQL> insert into t3 values(To_date('20:25','HH24:MI'));

1 row created.

SQL> select * from t3;

DAT
--------
10:25:00
10:10:10
20:25:00

SQL> alter session set nls_date_format='DD-MM-YYYY HH24:Mi:SS';

Session altered.

SQL> select * from t3;

DAT
-------------------
01-07-2006 10:25:00
01-07-2006 10:10:10
01-07-2006 20:25:00