Re: informix fraction

On 28 Aug 98 at 6:32, tolga@login.com.tr wrote: > Hi everybody, > Has anybody tried to use datetime fraction in stored procedure or > etc? 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. > My customer needs all the fractions of the current time. > Is there any way to do this? > Any info will help me great. If you're using Informix-Dynamic Server (v7.x), check in $INFORMIXDIR/etc/onconfig for a variable called USEOSTIME. If this is set, you're using OS time which does not support fractions of a second. I think. HTH. -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________