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