Oninit cdi / Archive
Talk to an expert →

Re: IDS 7.3 : Stored procedures tuning

Posted in 2000

Topics: Performance & Tuning, Stored Procedures & SPL, Server Administration, Versions, Editions & End-of-Life

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

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!!!" :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Leonids.Voroncovs@dati.lv — — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > > > >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!!!" :-) Out of topic. We are speaking about Informix engine which can't get correct time from OS.

Glossary