| Subject | Re: [firebird-support] get float part of a number... |
|---|---|
| Author | Doru Constantin |
| Post date | 2004-02-04T11:19:31Z |
Alex Taylor wrote:
SELECT 123.55 - CAST(123.55 AS NUMERIC(10,0)) FROM RDB$DATABASE
you will get -0.45 not 0.55!!! (NUMERIC(10,0) will round 123.55 to 124)
> SELECT FLOAT_NUMBER-CAST(FLOAT_NUMBER AS NUMERIC(10,0)) FROM TABLE_NAMENo. If you
SELECT 123.55 - CAST(123.55 AS NUMERIC(10,0)) FROM RDB$DATABASE
you will get -0.45 not 0.55!!! (NUMERIC(10,0) will round 123.55 to 124)