Re: Informix 4GL Bug Impacting Datetime Fields

The bug is now 3 digits on my AIX 4.1.4 OS system with Informix 7.12UC2 IBM RS6000: defined column tm_last_update datetime year to fraction(5) It value returned in one case: tm_last_update 1996-07-10 15:27:51.30300 ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Sat, 13 Jul 1996, Koen Van der Elst wrote: > On 8 Jul 1996 08:38:25 -0400, cherylk@prod1.jcdc.doleta.gov (Cheryl > Kendricks) wrote: > > >If you set the USEOSTIME=1 in your config file you could suddenly see the > >fraction of a seconds appear. This config variable applies to 7.X engine. > >The default is 0. In your orginal post James you did not include what > >engine you are using. Hopes this helps! > > Yep this works alright. Only one minor problem : there is an Informix > confirmed bug in Online 7.1x : fractions are limited to 2 digits. You > can never get fraction(5). > > Koen. > >