| Subject | Re: [firebird-support] Maths problem 1.0(Dialect 1) -> 1.5(Dialect 3) |
|---|---|
| Author | Lester Caine |
| Post date | 2003-09-01T16:22:51Z |
>>TryActually
>>CAST (CURRENT_DATE - OLD.LAST) * 1440) AS INTEGER
>
> should be CURRENT_TIMESTAMP, of course. Sorry. Time for me to crash for
> the day, methinks.
(CURRENT_DATE - OLD.LAST) * 1440
Works on it's own!
So just have to replace the 'NOW' with CURRENT_DATE :)
Thanks Helen
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services