| Subject | Re: [firebird-support] Re: real type calculation fields |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2011-01-13T12:09:51Z |
Hello Ahmet,
If the calculation result (or a float/double value in general) is _roughly_ within the range
-92,000,000,000,000,000 .. 92,000,000,000,000,000
...then you can cast it like this:
cast(Expression as numeric(18,2))
'Expression' is whatever expression you use in your view definition to calculate the result.
Paul Vinkenoog
> how can i cast 2 digits after the decimal point?Is it possible for you to show us the view definition as it is now, and the types and ranges of the relevant columns in the base tables?
If the calculation result (or a float/double value in general) is _roughly_ within the range
-92,000,000,000,000,000 .. 92,000,000,000,000,000
...then you can cast it like this:
cast(Expression as numeric(18,2))
'Expression' is whatever expression you use in your view definition to calculate the result.
Paul Vinkenoog