Re: Why the following.......?

Brian Li (cphdcbl@ted.cs.depaul.edu) wrote: : select : datetime(1996-05-31) year to day - interval(1-1) year to month : from tbsctupd : where : subsystem_id_ind = 'j' and : subfunction_code = 'date'; : # ^ : # 1267: The result of a datetime computation is out of range. : # Well, it's pointint in the wrong place, but the problem is that 13 months before 1996-05-31 would be 1995-04-31, and April doesn't have 31 days. June (bracing herself for the ensuing brawl...) ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Miami ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.