--- In firebird-support@yahoogroups.com, "Steve Harp" <steve@h...>
wrote:

>
> 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

passed

> since a timestamp field had been updated with CURRENT_TIMESTAMP, how
> would I do this?
>
> Thanks,
> Steve
>

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).

Adam