RE: [GENERAL] decimal(9.2)

Try:

dbhpw=> create table therbert (num numeric(9,2));

H.P.

On 25-Jun-99 Herbert Liechti wrote:
> 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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----------------------------------
E-Mail: Hans Peter Würmli <wurmli@datacomm.ch>
Date: 25-Jun-99
Time: 20:36:00

This message was sent by XFMail
----------------------------------