RE: Current time in a procedure ??!!

Posted in 2003

Alexey Sonkin — Mon, 3 Nov 2003 15:27:15 -0500 — source: Usenet: comp.databases.informix

You are wrong: select DBINFO('utc_to_datetime',sh_curtime) into end_time from sysmaster:'informix'.sysshmvals; works perfectly from SP, if 1 second accuracy is enough ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: problems [mailto:member46368@dbforums.com] > Sent: Monday, November 03, 2003 10:30 AM > To: informix-list@iiug.org > Subject: Re: Current time in a procedure ??!! > > > those solutions don't work ! > > > > it seems that I can't have the current time in a statement even if I > call an other function. The current time stop at the begening of a > procedure. How can i get the OS time in an informix function ??? > > > -- > Posted via http://dbforums.com sending to informix-list