Adding the Month

somu_june · Post by **somu_june** » Thu Dec 13, 2007 9:34 am

Hi,

I have a requirement like this . I need to add a month from input date which Iam getting as varchar (8) . For example 20071201 it must be 20080101 and it must take care of leap years also . Can some body help me in this.

Thanks,
Somaraju.

DSguru2B · Post by **DSguru2B** » Thu Dec 13, 2007 9:40 am

You will have to create your own, nothing is provided out of the box.

JoshGeorge · Post by **JoshGeorge** » Thu Dec 13, 2007 2:39 pm

FLOOR(No_Of_Months/12) will give you years to be added/subtracted and
(No_Of_Months MOD 12) will give you months to be added/subtracted

This should give you the lead to your solution. A solution to subtract months is given in this LINK, tweak this code if you want to add, won't be that difficult.

paddu · Post by **paddu** » Fri Dec 14, 2007 4:24 pm

Do exact Search on "AddMonths routine" ,you may find some ways to achieve your requirement.

Paddu