SQLite Forum

Calculating Trip Duration
Login

Calculating Trip Duration

(1) By David Jackson (davidjackson) on 2021-07-28 22:58:14 [link]

How can I use a case statement to calculate trip duration?

end_datetime - start_endtime = trip duration.
If the trip duration is less than 0 then I want to do:
start_endtime - end_datetime = trip duration.

Here is the code I'm trying to use:

Select case when datediff(minute, started_at, ended_at) < 0 
then 
	datediff(minute, ended_at, started_at)
else 
datediff(minute, started_at, ended_at) 
 end
 
 FROM detail

Thanks,
David

(2) By Warren Young (wyoung) on 2021-07-28 23:26:27 in reply to 1

Why not just write `abs(datediff(...))`? [See the docs](https://sqlite.org/lang_corefunc.html#abs).

…and then ask why you've got your start and end times swapped.