Re: CURRENT date precision

Posted in 1996

Koen Van der Elst — 29 Jul 1996 17:34:41 GMT — source: Informix-list mailing list archive (1991-1998)

> > I'm using a DATE YEAR TO FRACTION(3) field as a key in a table. I'm not > > getting the precision I expect in the following statement: > > > > LET var = CURRENT YEAR TO FRACTION(3); > > > Firstly check your release notes. Not all platforms support sub-second precision. If > yours does, then set the configuration parameter USEOSTIME=1 in your configuration file. > First make sure that USEOSTIME variable in you ONCONFIG file is set to 1. Restart Informix if you change the value (I had to reboot my server !). After that, you'll have fractions. But : there is an Informix confirmed bug in Online 7.1x. Fractions are always limited to 3 and on some platforms (e.g. SCO Unix) to 2 digits, even if you specify FRACTION(5). Apparently this bug will be fixed in version 7.2 Koen