>
> > Yup. Linguistic confusion. TIME answers the question "what is the
> time?",
> > not "what time did it take?"
> >
> Helen,
> excuse me if i wrong, but,
> we can use TIME data type to store elapsed time if we have good enough
> reasons.
> 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.

<buzzer> Wrong!

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:
http://groups-beta.google.com/group/borland.public.delphi.non-technical/browse_frm/thread/2ec381dda8610699/fcc8939b1d816717?q=martijn+delphi+group:borland.public.*+author:craig&rnum=2#fcc8939b1d816717



With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com