Re: Problem with Intervals
If he did: - interval(100) day(3) to day it should work. Unless you qualify the first part of a datetime or interval it goes to it's default length - for "day" that is 2. "100" has 3 digits and overflows. Guess what you need to do for 1000 days? cheers j. davin_harvey@dsti.co.uk on 05/11/98 12:40:02 PM To: informix-list@iiug.org, ccremid@saadev.saa.noaa.gov cc: (bcc: Jack Parker/Boston50/Epsilon) Subject: Re: Problem with Intervals Tino, No idea why it doesn't work, but select current year to day - 100 units day from systables where tabid = 1 does work HTH Davin ______________________________ Reply Separator _________________________________ Subject: Problem with Intervals Author: MIME {ccremid@saadev.saa.noaa.gov} at INTERNET Date: 11/05/1998 15:08 Hello: Can any of you, Informix gurus, provide an explanation why: SELECT current year to day - interval(99) day to day from systables where tabid = 1 Works just fine, but SELECT current year to day - interval(100) day to day from systables where tabid = 1 Fails with error -201 (Syntax error) As a mater of fact any time that interval goes over 99 fails regarless of what the qualifier is. TIA Tino Just in case: AIX 4.2 and Online 7.23 ********************************************************************** DST International Tel:+44 181 390 5000 www.dstinternational.co.uk This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately by telephone on the number above and destroy the message and all copies in your possession. **********************************************************************