Subject Re: Calculating seconds since TimeStamp
Author Adam
--- In, "Steve Harp" <steve@h...>
> Hi All,
> I'm not sure how date math is done in Firebird. What's the easiest
> way to calculate the number of seconds since a timestamp? For
> instance, if I wanted to determine if 10 minutes or 1 hour had
> since a timestamp field had been updated with CURRENT_TIMESTAMP, how
> would I do this?
> Thanks,
> Steve


The difference between two timestamps returns the number of days, so
multiply that by whatever to get the number of hours (24), minutes
(1440) or seconds (86400).