Problem with Intervals

Posted in 1998

ccremid — Mon, 11 May 1998 09:33:18 -0400 — source: Informix-list mailing list archive (1991-1998)

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

Related threads

Force Assert Fail
IDS Function problem