Re: add two months into the column

In article <34efb91a.394538346@news.sysnet.net.tw>, Edmond Chang <edmond@tpts1.seed.net.tw> wrote: >Is anyone can tell me how to add months into >a column in my table ? You can add a MONTH TO MONTH interval (e.g. 2 UNITS MONTH) to a DATETIME.... for a DATE, you can do your math in DATETIMEs and convert back. *BUT* You will have to use special handling for those situations where the addition results in an invalid date (e.g. December 31 plus 2 UNITS MONTH will produce an error per ANSI) -- you need to define your own rules for how you want those handled and then do those changes programmatically... -- Alan Denney yosemite_at_netcom.com Look for me on the California Attorney General's Tamagotchi-abuser CD-ROM.