Re: Current function does not work!

Posted in 1998

Stefan Weideneder — Tue, 28 Jul 1998 21:06:45 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi Wolf, I would recommend to contact your Technical Support, because this behaviour looks like a BUG. Bye Stefan Weideneder Wolf Peter wrote: > > HOW can I GET the real current time in stored procedure call? > > These test program proofs that the built-in current function in a stored > > procedure the procedure returns the time when the procedure BEGAN not > the CURRENT time! > > create procedure test() returning datetime year to second;> > define i int; > > for i= 1 to 5 > return current do with resume; > system( 'sleep 3' ); > end for; > > end procedure; > > The execute procedure test() > returns > 1998-07-13 11:33:53 > 1998-07-13 11:33:53 > 1998-07-13 11:33:53 > 1998-07-13 11:33:53 > 1998-07-13 11:33:53 > > Please send the answers to my e-mail and not only to the message group.