precision in the date/time field
A poster wanted fractional seconds from select current but always got .000. Sergey E. Volkov suggested USEOSTIME=1 in onconfig, which did not help the poster. smooth1 said the fraction is not available on some operating systems and advised checking the release notes under INFORMIXDIR. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
When I do 'select current' I always get .000 in the decimal part of the time field (11:35:18.000). How can I get the exact time, for example 11:35:18.133 Thank you! Sent via Deja.com http://www.deja.com/ Before you buy.
Try to set USEOSTIME=1 in onconfig. Good luck!. Sergey. <jobmail@my-deja.com> ''''' ' ''''''''':8sl4l0$ieh$1@nnrp1.deja.com... > When I do 'select current' I always get .000 in the decimal part of the > time field (11:35:18.000). How can I get the exact time, for example > 11:35:18.133 > > Thank you! > > > Sent via Deja.com http://www.deja.com/ > Before you buy.
Thank you for the advice. I still cannot get the decimal part printed correctly, though, even when I change USEOSTIME from 0 to 1. In article <8sm5ot$ea12@www.informix.com>, "Sergey E. Volkov" <sve@raiden.bancorp.ru> wrote: > Try to set USEOSTIME=1 in onconfig. > > Good luck!. > > Sergey. > > <jobmail@my-deja.com> ''''' ' ''''''''':8sl4l0$ieh$1@nnrp1.deja.com... > > When I do 'select current' I always get .000 in the decimal part of the > > time field (11:35:18.000). How can I get the exact time, for example > > 11:35:18.133 > > > > Thank you! > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.
jobmail@my-deja.com wrote in message <8sq40d$jif$1@nnrp1.deja.com>... >Thank you for the advice. I still cannot get the decimal part printed >correctly, though, even when I change USEOSTIME from 0 to 1. > On some operating systems the fraction part is not available. Check the release notes under $INFORMIXDIR/release