Re: RE: Where are the fractions of a second of CURRENT?

On Fri, 24 Sep 2004 18:54:14 -0400, Jean Sagi wrote: That's USEOSTIME 1 The performance penalty is real but not great. Art S. Kagel > Ummmm... > > There is a _severe_ performace penalty if our DBA do this? > > Chucho! > > > -----Original Message----- > From: "Everett Mills" <eemills@nationalbeef.com> To: > <informix-list@iiug.org> > Date: Fri, 24 Sep 2004 16:54:35 -0500 > Subject: RE: Where are the fractions of a second of CURRENT? > > Jean- > You need to have: > > USOSTIME 1 > > set in your onconfig. Otherwise Informix only updates the time once a > second. > > --EEM > >> -----Original Message----- >> From: Jean Sagi [mailto:jeansagi@myrealbox.com] Sent: Friday, September 24, >> 2004 4:11 PM To: informix-list@iiug.org; jeansagi@myrealbox.com Subject: >> Where are the fractions of a second of CURRENT? >> >> >> I haven'''t seen this before, but when in dbaccess I issue: >> >> select current >> from dual>> ; >> >> Informix returns: >> >> ct >> ----------------------- >> 2004-09-24 16:06:37.000 >> >> 1 row(s) retrieved. >> >> I keep the RUN option (holding R pressed) and I see how the second pass but >> I don't see the fractions of the second... >> >> Why? >> >> If I issue: >> >> select extend(current, year to fraction(5)) ct from table( set{1} ) >> >> Yet no joy: >> >> ct >> ------------------------- >> 2004-09-24 16:09:14.00000 >> >> Really interesting? >> >> - Maybe is a disabled option? >> - it's dbaccess? (Although Winsql shows the same behavior). - It's the >> engine >> >> >> Rigth know I'm using >> - IDS 9.30.HC2W8 >> - HP-UX ipsilon B.11.00 >> >> Any hint would be very appreciated. >> >> >> Chucho! >> >> Jean Sagi >> jeansagi@myrealbox.com >> jeansagi@yahoo.com >> >> sending to informix-list > > sending to informix-list > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@yahoo.com > > sending to informix-list