| Subject | Re: [firebird-support] real type calculation fields |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2011-01-13T10:12:26Z |
Hello Ahmet,
Anyway, to see exactly 2 digits after the decimal point, you can cast the result to NUMERIC(18,2).
If the result is outside the NUMERIC range, the easiest solution is probably to let your application handle the formatting.
Hope this helps,
Paul Vinkenoog
> Hi, I use Firebird 2.5. I have a computing in my view. It can calculate but there are a lot of number decimally. For example result should be "2.03" but firebird send me "2.00000003" I want to see 2 digit after point. How can I set it?2.00000003 instead of 2.03 would be an error. Maybe you mean 2.03000000?
Anyway, to see exactly 2 digits after the decimal point, you can cast the result to NUMERIC(18,2).
If the result is outside the NUMERIC range, the easiest solution is probably to let your application handle the formatting.
Hope this helps,
Paul Vinkenoog