Re: SQL: Duration Question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 3 Dec 2006 18:27:44 +0100
Message-ID: <45730914$0$15889$426a74cc@news.free.fr>

"Charles Hooper" <hooperc2000_at_yahoo.com> a écrit dans le message de news: 1165157716.914074.210880_at_80g2000cwy.googlegroups.com...

<snip>

| Charles Hooper
| PC Support Specialist
| K&M Machine-Fabricating, Inc.

|

I don't fully read your answer but you can't give any answer until my previous question is not itself answered:

"If for a car you have a trip from 1:00 to 1:30 and for another one a trip from 1:35 to 1:50, do you have 1 or 2 cars for 01 slot?"

Moreover you made the assumption that trips are recorded at the second, in the real world it is more likely at the minute (or even more likely at the quarter of hour). You also made many other assumptions.
Finally, you answered a problem but this may not be the OP one.

Regards
Michel Cadot Received on Sun Dec 03 2006 - 11:27:44 CST