Subject Re: [ib-support] Calculating elapsed time
Author Lester Caine
Sandor Szollosi wrote:
> Hi Folks!
>
> My Table1 has a timestamp field which always updated when user
> modífies the record.
>
> Is there a way to select the elapsed minutes from this field?
> I'd like to get minutes.
> (current_timestamp - Mytime_field = ?)

CAST ( ( 'NOW' - MYTIMESTAMP ) *1440 AS INTEGER )

Works for me <g>

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services