Subject | How to limit FLOAT's precision to .000 |
---|---|
Author | peter_nn0 |
Post date | 2006-04-10T22:23:47Z |
Hi,
I'm new to databases and FB in particular, so excuse me if the question
is sort of stupid.
I have in some tables fields of type FLOAT which are filled by stored
procedures.
Now the values in these fields are stored with tons of digits after the
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?
Thanks
I'm new to databases and FB in particular, so excuse me if the question
is sort of stupid.
I have in some tables fields of type FLOAT which are filled by stored
procedures.
Now the values in these fields are stored with tons of digits after the
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?
Thanks