Re: informix fraction

Posted in 1998

Jonathan Leffler — Fri, 28 Aug 1998 10:51:37 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

On Fri, 28 Aug 1998 tolga@login.com.tr wrote: > Has anybody tried to use datetime fraction in stored procedure or etc? Yes. > I have a problem with this: > In dbaccess, followin sql statement does not do what i want: > select current year to fraction(5) > In result,there is no fraction. Because your OnLine system is configured with USEOSTIME 0 in your $ONCONFIG file. > My customer needs all the fractions of the current time. > Is there any way to do this? So set USEOSTIME 1 in $ONCONFIG and reboot OnLine. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn