How to calculate the difference in minutes between timestamps TIMEIN and TIMEOUT? My table (only 3 rows):

My SQL doesn't output what I want:

SELECT (T.DATE   T.TIMEIN - T.DATE   T.TIMEOUT) AS `Duration`

FROM Transport T;

Output:

It should be :

I tried this without using the date, however that lead to an output of -1 for all rows.

CodePudding user response：

Assuming that TIMEOUT is always greater than TIMEIN you can subtract the unix epochs of the 2 values and divide by 60 to get the number of minutes:

SELECT (strftime('%s', TIMEOUT) - strftime('%s', TIMEIN)) / 60 AS Duration
FROM Transport;

See the demo.

CodePudding user response：

date/time is not like integers so they didn't add/subtract like integers. So convert them in a timestamp before subtraction.