Subject | Calculating seconds since TimeStamp |
---|---|
Author | Steve Harp |
Post date | 2005-11-21T04:37:35Z |
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
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