| Subject | i64Truncate (FB 1.5) |
|---|---|
| Author | d_dude_2003 |
| Post date | 2006-04-19T12:01:06Z |
I am trying to use i64Truncate from fdudf.dll but it works like Round.
SELECT i64Truncate(CAST(((T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)
*24) AS NUMERIC)) return 9 instead of 8 when
(T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)*24) is 8.822...
SELECT i64Truncate(((T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)*24)
returns NULL
How its supposed to work?
How i can get 8 out of 8.822....?
SELECT i64Truncate(CAST(((T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)
*24) AS NUMERIC)) return 9 instead of 8 when
(T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)*24) is 8.822...
SELECT i64Truncate(((T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)*24)
returns NULL
How its supposed to work?
How i can get 8 out of 8.822....?