Oracle 21c

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

CREATE TABLE table_name (
  FlightDate    DATE
                CONSTRAINT table_name__flightdate__chk CHECK (flightdate = TRUNC(flightdate)),
  DepartureTime INTERVAL DAY(0) TO SECOND(0) NOT NULL,
  ArrivalTime   INTERVAL DAY(1) TO SECOND(0) NOT NULL
);
INSERT INTO table_name (
  flightDate, DepartureTime, ArrivalTime
) VALUES (
  DATE '2022-11-25',
  INTERVAL '12:34' HOUR TO MINUTE,
  INTERVAL '1 02:15' DAY TO MINUTE
);
1 rows affected

INSERT INTO table_name (
  flightDate, DepartureTime, ArrivalTime
) VALUES (
  DATE '2022-11-25',
  INTERVAL '23:59' HOUR TO MINUTE,
  INTERVAL '25' HOUR + INTERVAL '2' MINUTE
);
1 rows affected

INSERT INTO table_name (
  flightDate, DepartureTime, ArrivalTime
) VALUES (
  DATE '2022-11-25',
  NUMTODSINTERVAL( 12.5, 'HOUR' ),
  NUMTODSINTERVAL( 15*60 + 43, 'MINUTE' )
);
1 rows affected

SELECT * FROM table_name;


FLIGHTDATE
DEPARTURETIME
ARRIVALTIME


25-NOV-22
+0 12:34:00
+1 02:15:00

25-NOV-22
+0 23:59:00
+1 01:02:00

25-NOV-22
+0 12:30:00
+0 15:43:00


SELECT TO_CHAR(flightdate + departuretime, 'YYYY-MM-DD HH24:MI:SS') AS departuretime,
       TO_CHAR(flightdate + arrivaltime, 'YYYY-MM-DD HH24:MI:SS') AS arrivaltime
FROM   table_name;


DEPARTURETIME
ARRIVALTIME


2022-11-25 12:34:00
2022-11-26 02:15:00

2022-11-25 23:59:00
2022-11-26 01:02:00

2022-11-25 12:30:00
2022-11-25 15:43:00

FLIGHTDATE	DEPARTURETIME	ARRIVALTIME
25-NOV-22	+0 12:34:00	+1 02:15:00
25-NOV-22	+0 23:59:00	+1 01:02:00
25-NOV-22	+0 12:30:00	+0 15:43:00

DEPARTURETIME	ARRIVALTIME
2022-11-25 12:34:00	2022-11-26 02:15:00
2022-11-25 23:59:00	2022-11-26 01:02:00
2022-11-25 12:30:00	2022-11-25 15:43:00