Re: Informix 4GL Bug Impacting Datetime Fields

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 > of the second. This was explained away by > Informix tech support as a "Known Bug" > impacting all platforms/ports, but there > is no known date or revision for a fix. 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 al. I had the same experience as you (sans calling tech support), on the Unisys box until the appropriate libraries were installed. I don't know immediately which libararies are required, although I seem to recall them being documented in release notes. Contact tech support again, tell them what I told you, and if they can't help you identify the libraries I'm talking about, have them call me. > ... > > 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