> Martijn,
>
> M> Actually, dividing a TIME by 2 would give you an INTERVAL,
> M> which is perfectly computable (if the type existed in Fb).
>
> no it won't, and it doesn't make sense either.
>
> INTERVAL / NUMERIC yelds an INTERVAL, but / is not a supported
> operation for the TIME datatype (according to the SQL standard and
> common sense).
>
> Your point is taken, though.

Nando, you are correct - it does not make sense to divide time :-)

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