Re: IDS 7.3 : Stored procedures tuning

Posted in 2000

Jonathan Stowe — Fri, 7 Apr 2000 15:52:14 +0100 (GMT Daylight Time) — source: Informix-list mailing list archive (1991-1998)

On Fri, 7 Apr 2000, Obnoxio The Clown wrote: > From: Leonids.Voroncovs@dati.lv > > > >Obnoxio The Clown wrote: > > > > > >The CURRENT function always returns result wich precision is > >'truncated' to > > > >second format (fraction part of datetime is always 000) : '2000-04-04 > > > >15:21:54 000'. I get this result either in an SQL statement or in a SP. > >I > > > >read that CURRENT rely on the system date and time API ; I suppose that > > > >WinNT > > > >knows millisecond ! So I do not really understand what is the problem ! > > > > > > In your onconfig file, set USEOSTIME to 1. > > > >Doesn't works! > > All together now: "USE A REAL OPERATING SYSTEM!!!" :-) But there isnt an Informix port to GNU/Hurd ;-] /J\\ -- Jonathan Stowe <mailto:Jonathan.Stowe@dircon.net> Analyst/Programmer, Direct Connection Connection House, 9 Selsdon Way, Cityharbour, London E14 <http://www.dircon.net>;