Zeit zwischen zwei Time Felder

[KodeZwerg]

Vielleicht versteht es das?

Delphi-Quellcode:

SELECT
 id,
 departure,
 arrival,
 FLOOR(TIMESTAMPDIFF(SECOND, departure, arrival) / 3600 / 24), ' days ',
 FLOOR(TIMESTAMPDIFF(SECOND, departure, arrival) % 3600 / 3600), ' hours ',
 FLOOR(TIMESTAMPDIFF(SECOND, departure, arrival) % 3600 % 60), ' minutes ',
 TIMESTAMPDIFF(SECOND, departure, arrival) % 60, ' seconds'
FROM travel;