--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...>
wrote:

> Hi,
>
> At September 27, 2004, 15:47, trac_t2000 wrote:
>
> > I am trying to record the time it takes for certain lines of sql

to

> > run in a stored procedure. I added a "Process_log" table that

holds

> > a varchar and a timestamp. I am inserting a start and finish

record

> > in this new "Process_Log" table for each particular sql

operation.

> > Well, my problem is the time stamps are the same for every

record.

> > This procedure takes about 5 minutes to run, but all the time

stamps

> > are equal.
>
> > I am using firebird 1.5 on Windows 2000 operating system.
>
> What are you using to get the timestamp? CURRENT_TIMESTAMP or 'NOW'?
>

I am using CURRENT_TIMESTAMP.

> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)