add 30 days from a given date

[Member 3879881]

Hi i have one doubt..., I want to add a month from the given date..., Mean suppose if i give a date(mm/dd/yyy)='01/01/2008' from that add 30 days and give '31/01/2008' another example if i give '02/16/2008' add 30 days and give '03/16/2008' like this, how its possible?

Thanks & Regards, NeW OnE, please don't forget to vote on the post

[Syed Mehroz Alam]

You can use the DateAdd function. See msdn documentation here[^] Regard, Mehroz

[Khawar Abbas1]

select dateadd(day,30,columnname) from tablename

Do good and have good.

[Member 3879881]

thanks

Thanks & Regards, NeW OnE, please don't forget to vote on the post