Ali Gökçen wrote:

> we can use TIME data type to store elapsed time if we have good enough
> reasons.

Sure, and you can use varchars to store numbers, and then be surprised
that the don't sort "right". But that's not the way the data type is
intended to be used. Even though you understand that a time minus
another time is an interval which can be expressed in the same notation
as a time, the database knows that time and interval are different.

Regards,


Ann