TIMEDIFF

Parameters

datetime1DATETIME

Time or datetime to subtract datetime2 from

datetime2DATETIME

Value of the same type to subtract

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

Examples

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

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

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

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

Details

See also