Re: fractions

Posted in 2003

Will Slater — 23 Jun 2003 13:45:47 +0100 — source: Usenet: comp.databases.informix

On Mon, 2003-06-23 at 09:38, Arnel CUETO (DHL PH) wrote: > Gurus, > > I have some inquiries regarding the expression 'CURRENT' used in SQL. > Refering to the statement below : > > select current year to fraction(5) from [table_name] > > would produce a result: > > 2003-06-20 11:34:35.00000 > 2003-06-20 11:34:35.00000 > 2003-06-20 11:34:35.00000 > 2003-06-20 11:34:35.00000 > > Questions: > 1. Notice that the fraction(5) portion on the result set produces > '00000' value. Is there something that I need to set to produce this > segment? What value do you have for USEOSTIME in your onconfig? I think it needs to be set to 1 to get better than 1 second granularity, at least that seems to do the trick on solaris. > 2. have try to used the 'EXTEND' function but to no avail. Are there > any other function that might help? I'm using Informix7.31 in a > HPUX11.0 > environment. > > thanks in advance. > > Regards, > Arnel -- Will Slater Will.Slater@orbisuk.com Orbis Tel: +44 (0)20 8742 1600 www.orbisuk.com Fax: +44 (0)20 8742 2649 sending to informix-list