> > No, this isn't a "time", it's a "duration" or "interval". Something
> which
> > Firebird doesn't support.
> >
> Firebird supports mathmatic, it is enough.

You can do maths on it, I know.

But the "time" of 16:00 afternoon divided by 2 does
not give you a "time" value of 08:00 in the morning.
Let alone if you have the date of today at a certain
time.

Another example:
Oct 21 15:00 (which is a "date and time") minus 2 hours
(which is NOT a time) gives you Oct 21, 13:00.

See the "2 hours" part - that is a "duration", not a time.

Now, remove 1.5 days. You'll get Oct 20, 03:00.

But 1.5 days - how would you display that? No such thing
in a "date and time" format, is there?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com