| Subject | Maths problem 1.0(Dialect 1) -> 1.5(Dialect 3) |
|---|---|
| Author | Lester Caine |
| Post date | 2003-09-01T14:30:42Z |
OK what am I doing wrong?
(('NOW' - OLD.LAST) * 1440)
Is working fine in FB1.0 on a Dialect 1 database
(LAST is a TIMESTAMP, and the value goes into a SMALLINT)
CAST((CAST('NOW' AS TIMESTAMP) - OLD.LAST) AS INTEGER)* 1440
Will actually compile on FB1.5RC4 on a Dialect 3 database,
but it is not putting 'minutes' into the SMALLINT - I always
get 0.
This equation is used in several 'INSERT' triggers and all
give the same problem.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
(('NOW' - OLD.LAST) * 1440)
Is working fine in FB1.0 on a Dialect 1 database
(LAST is a TIMESTAMP, and the value goes into a SMALLINT)
CAST((CAST('NOW' AS TIMESTAMP) - OLD.LAST) AS INTEGER)* 1440
Will actually compile on FB1.5RC4 on a Dialect 3 database,
but it is not putting 'minutes' into the SMALLINT - I always
get 0.
This equation is used in several 'INSERT' triggers and all
give the same problem.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services