Re: Informix 4GL Bug Impacting Datetime Fields

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! ------------------------------------------------------------------------- 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 Wed, 3 Jul 1996, Dennis J Pimple wrote: } James Fischer wrote: } > } > Assume that you define a datetime value with a } > granularity of fractional seconds, for example: } > } > datetime(year to fraction) } > } > ... } > } > The "current" function will never return a } > value other than zero for the fractional part (SNIP....) } Not true. It's not a bug; your platform is missing some math libraries required for fractional } seconds. I've written datetime fractional code for (off the top of my head) HP, Unisys, SCO, et (SNIP....) } } > } > I used to Kick Butt, but now I Click Butt } > } > james fischer jfischer@supercollider.com } } -- } //////////////// ======================================================= } ////////// // Dennis J. Pimple Informix Software, Inc. } ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 } ///// // //// dennisp@informix.com Englewood CO 80111 } //// // ///// } /// // ////// recept: 303-850-0210 } // // /////// direct: 303-740-5611 Opinions expressed are mine, } / /////////// fax: 303-843-6408 and do not necessarily } //////////////// http://www.informix.com reflect those of my employer }