|Subject||Re: TimeStamp Problem in procedures|
--- In email@example.com, Daniel Rail <daniel@a...>
> At September 27, 2004, 15:47, trac_t2000 wrote:
> > I am trying to record the time it takes for certain lines of sql
> > run in a stored procedure. I added a "Process_log" table thatholds
> > a varchar and a timestamp. I am inserting a start and finishrecord
> > in this new "Process_Log" table for each particular sqloperation.
> > Well, my problem is the time stamps are the same for everyrecord.
> > This procedure takes about 5 minutes to run, but all the timestamps
> > are equal.I am using CURRENT_TIMESTAMP.
> > I am using firebird 1.5 on Windows 2000 operating system.
> What are you using to get the timestamp? CURRENT_TIMESTAMP or 'NOW'?
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)