Perfect, thank you.. One more question and Im done.. Helen, is there any way to delare any sort of array of values in a Stored Procedure? Im thinking no.

----- Original Message -----
From: Helen Borrie
To: IBObjects@yahoogroups.com
Sent: Monday, July 21, 2008 6:03 PM
Subject: Re: [IBO] Time Elapsed between Time stamps..


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




[Non-text portions of this message have been removed]