MySQL 8.0

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

select @@version;


@@version


8.0.30


CREATE TABLE Table_A (
  Id INT,
  IN_DATE DATETIME,
  OUT_DATE DATETIME,
  TOTAL_HOURS INT
)
INSERT INTO Table_A (Id, IN_DATE, OUT_DATE, TOTAL_HOURS)
SELECT 1, '2021-10-04 07:00:00', '2021-10-04 08:00:00',
TIMESTAMPDIFF(HOUR, '2021-10-04 07:00:00', '2021-10-04 08:00:00')
SELECT * FROM Table_A


Id
IN_DATE
OUT_DATE
TOTAL_HOURS


1
2021-10-04 07:00:00
2021-10-04 08:00:00
1