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(dot)Liechti(at)thinx(dot)ch
> ThinX networked business services Stahlrain 10, CH-5200 Brugg
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----------------------------------
E-Mail: Hans Peter Würmli <wurmli(at)datacomm(dot)ch>
Date: 25-Jun-99
Time: 20:36:00

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