At 09:55 22/07/2008, you wrote:

>I know this isnt exactly the right place to ask, but Im trying to write a stored procedure in firebird..In it I need to know how many seconds between 2 time stamps. Is there an easy way?

Subtract the earlier timestamp from the later one to get a NUMERIC(18,9) that is the difference (interval) in days. Multiply the result by 86400 to calculate seconds.

Helen