Re: fractions

Posted in 2003

Mark D. Stock — Mon, 23 Jun 2003 16:01:16 +0100 — source: Usenet: comp.databases.informix

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? Yes, make sure that USEOSTIME is set to 1 in your onconfig file. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list