AFAIK, using cast('now' as timestamp) will work.

CURRENT_TIMESTAMP is the time when the transaction started.


Regards,
Anderson

----- Original Message -----
From: "Sean" <firebird_tmc@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, July 13, 2007 4:52 PM
Subject: [firebird-support] how to measure stored procedure performance


Hi,

I have a stored procedure w/ multiple steps. In order to measure how
long each step takes, I output current_timestamp/current_time after
each step. But it seems the time doesn't change.

Is there a way to measure the time taken for each step?

Best,
Sean