Subject | Re: [firebird-support] How to limit FLOAT's precision to .000 |
---|---|
Author | Gary Benade |
Post date | 2006-04-11T15:05:38Z |
> Now the values in these fields are stored with tons of digits after theDont use a float, use a numeric instead
> decimal point, like 12.1234567890123
> I do not need and want to avoid this, would like to have not more than
> 3 digits after the decimal point - like 12.123
> How?
ie. numeric(8,3) . the ,3 indicates how many digits can be stored to the
right of the decimal point, and the 8 how many to the left.
HTH
Gary