RE: Informix 4GL Bug Impacting Datetime Fields
Posted in 1996
--- On Wed, 10 Jul 1996 15:22:23 MDT, thus spoke the "Jack": }> }> I came across an interesting problem that may be }> of concern to other Informix 4GL developers. }> }> Assume that you define a datetime value with a }> granularity of fractional seconds, for example: }> }> datetime(year to fraction) }> }> The only tool available within 4GL to get }> the time of day is the 4GL "current" function, }> but don't expect to get a time value from the }> 4GL "current" function with granularity more }> accurate than whole seconds. } }Interesting, I have successfully used it to FRACTION(2) but no further under }HP-UX. Of course I have no way to verify whether the fractions in }question have been accurate. } I seem to remember reading somewhere in the release notes (or some other such doc) that the datetime precision is a OS dependent feature. There it was also stated that for my boxes, fractions where not available and therefore set to zero by current. ciao (which in venetian dialect means 'slave of yours', so don't take me too seriously), marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117