Re: INTERVAL FUNCTION

Posted in 2003

Mark D. Stock — Thu, 24 Jul 2003 10:46:38 +0100 — source: Usenet: comp.databases.informix

Andrew Hamm wrote: > Mark D. Stock wrote: > >>tomL wrote: >> >>>why does the above statement work but when i replace 99 with 100, it >>>fails? >> >>Because you need to alter the precision of the INTERVAL to SECOND(3). > > Don't you mean: > "What do IBM Informix tech support say?" No, clearly this would be RTFM. <Tut> Andrew! 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