Hi,

For currency, I use NUMERIC(18, 2) mostly.

> I'm using Firbird 1.0 at windows 2000 server. What's the good datatype for
> currency and hour:minute data ?

And this hour-minute thing is duration? If so store it as
minutes/milliseconds/
whatever into a NUMERIC(18, 0) column.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."