Re: Problem with Intervals

Tino How about: SELECT current year to day - interval(100) day(3) to day from systables where tabid = 1 ; This works. Maybe because day is configured by default to be 2 digits long. HTH Sujit Pal ______________________________ Reply Separator _________________________________ Subject: Problem with Intervals Author: ccremid <ccremid@saadev.saa.noaa.gov> at internet Date: 5/11/98 9:33 AM 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