January 15th, 2011, 09:01 AM
|
|
Contributing User
|
|
Join Date: Jan 2007
Posts: 31
Time spent in forums: 13 h 12 m 34 sec
Reputation Power: 7
|
|
Quote: | Originally Posted by AhmetNuri 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? |
In the definition of your view , you can put a cast on the field that is a computing :
cast(sum(....) as numeric(15,2))
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
