Thread: decimal(9.2)

decimal(9.2)

From
Herbert Liechti
Date:
Hello

How do I define the datatype decimal(9.2). I searched the documentation but the only thing I found
was the money data type which is in my case not very usefull.

Is there a way to declare a datatype with 2 decimal places and with a fixed precision?
Thanks for your help

Herbie

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~