Subject | Re: [ib-support] Calculating elapsed time |
---|---|
Author | Lester Caine |
Post date | 2003-02-11T16:09:43Z |
Sandor Szollosi wrote:
Works for me <g>
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> Hi Folks!CAST ( ( 'NOW' - MYTIMESTAMP ) *1440 AS INTEGER )
>
> 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 = ?)
Works for me <g>
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services