Re: Informix 4GL Bug Impacting Datetime Fields

John H. Frantz wrote: > > James Fischer wrote: > > > > I came across an interesting problem that may be > > of concern to other Informix 4GL developers.<SNIP> > > 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. > > This bug is not exclusive to Informix-4gl. If you try the following<SNIP> > Thanks for the pointer. I hadn't noticed this bug before. Come on, I'm sure there were a number of replies to this! I'm not going to put my balls on the block and say this is not a bug, but my quess is that THIS IS NOT A BUG. The precision of current is determined by the operating system. Some OS's do not support the calls Informix use, therefore Informix sets the time every second. In version 7.00 you can switch this function on and off with the configuration parameter USEOSTIME (or some such name). 0=off, 1=on. Hope this helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |Email: marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+