|Subject||Re: [firebird-support] Re: TIME calculation errors|
> > Yup. Linguistic confusion. TIME answers the question "what is the
> > not "what time did it take?"
> excuse me if i wrong, but,
> we can use TIME data type to store elapsed time if we have good enough
> if both time values in same day, we can use delta value to reset
> start_time, to use as chronometer.
> TIME allways gives an elapsed value if u ask "what is the time?"
> because there is no date info in it.
> so "what is the time?" is actually mean of "what time did it take?"
> from midnight.
It's not "what time did it take" but "how long did it take" or
"what amount of time did it take" which results in a DURATION.
The datatype TIME or DATE should not be misused for duration.
There should be a datatype named "interval" for this.
Also check this thread:
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL