Re: Problem with Intervals

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Tino, =20 No idea why it doesn't work, but =20 select current year to day - 100 units day from systables where tabid =3D 1 =20 does work =20 HTH Davin ______________________________ Reply Separator ____________________________= _____ Subject: Problem with Intervals Author: MIME {ccremid@saadev=2Esaa=2Enoaa=2Egov} at INTERNET Date: 11/05/1998 15:08 Hello: Can any of you, Informix gurus, provide an explanation why: =20 SELECT current year to day - interval(99) day to day=20 from systables where tabid =3D 1=20 Works just fine, but =20 SELECT current year to day - interval(100) day to day from systables where tabid =3D 1 Fails with error -201 (Syntax error) =20 As a mater of fact any time that interval goes over 99=20 fails regarless of what the qualifier is=2E=20 =20 TIA=20 =20 Tino =20 Just in case: AIX 4=2E2 and Online 7=2E23 =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--