Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE times1 ( value INTERVAL DAY TO SECOND );
INSERT INTO times1 ( value ) VALUES ( INTERVAL '12:40' HOUR TO MINUTE );
1 rows affected

SELECT * FROM times1;


VALUE


+00 12:40:00.000000


CREATE TABLE times2 ( value DATE );
INSERT INTO times2 ( value )
-- Fixed date
SELECT DATE '1970-01-01' + INTERVAL '12:40' HOUR TO MINUTE FROM DUAL UNION ALL
-- Today's date
SELECT TRUNC( SYSDATE ) + INTERVAL '12:40' HOUR TO MINUTE FROM DUAL UNION ALL
-- First of current month
SELECT TO_DATE( '12:40', 'HH24:MI' ) FROM DUAL;
3 rows affected

SELECT value, TO_CHAR( value, 'HH24:MI' ) FROM times2;


VALUE
TO_CHAR(VALUE,'HH24:MI')


1970-01-01 12:40:00
12:40

2020-08-05 12:40:00
12:40

2020-08-01 12:40:00
12:40

VALUE	TO_CHAR(VALUE,'HH24:MI')
1970-01-01 12:40:00	12:40
2020-08-05 12:40:00	12:40
2020-08-01 12:40:00	12:40