TIMEDIFF

Devuelve la diferencia entre dos horas o entre dos valores de fecha y hora.

MySQL 8.4

TIMEDIFF(datetime1, datetime2)

Valor devuelto

Hora (TIME); puede ser negativa y superar las 24 horas, pero como máximo 838:59:59; NULL si los argumentos son de tipos distintos

MySQL 8.4

SELECT TIMEDIFF('2022-12-05 18:00:00', '2022-12-05 14:30:00') AS diff;

diff
03:30:00

MySQL 8.4

SELECT id,
	town_from,
	town_to,
	TIMEDIFF(time_in, time_out) AS duration
FROM Trip;

id	town_from	town_to	duration
1100	Rostov	Paris	03:20:00
1101	Paris	Rostov	03:33:00
1123	Rostov	Vladivostok	11:20:00
1124	Vladivostok	Rostov	10:50:00
1145	Moscow	Rostov	01:48:00
1146	Rostov	Moscow	02:06:00
1181	Rostov	Moscow	01:49:00
1182	Moscow	Rostov	01:55:00
1187	Rostov	Moscow	01:57:00
1188	Moscow	Rostov	01:58:00

MySQL 8.4

SELECT TIMEDIFF('14:00:00', '18:00:00') AS diff;

diff
-04:00:00

MySQL 8.4

SELECT TIMEDIFF('2022-12-05 18:00:00', '2021-12-01 14:00:00') AS diff;

diff
838:59:59

Para obtener la diferencia en segundos, envuelve el resultado en TIME_TO_SEC o usa TIMESTAMPDIFF.