TIMEDIFF

Returns the difference between two time or datetime values.

MySQL 8.4

TIMEDIFF(datetime1, datetime2)

Return value

A time (TIME), can be negative and longer than 24 hours, but not beyond 838:59:59; NULL if the arguments have different types

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

To get the difference as a number of seconds, wrap the result in TIME_TO_SEC or use TIMESTAMPDIFF.