how to add one month from the current month using datepart

See more:

SQL-Server

how to add one month from the current month using datepart

for the above thing i written the query as follows


select datepart(month,getdate()) as Month

when i execute the output as follows

Month
7

it is working correctly, suppose current month is December when i execute the above query

the output as follows,

select datepart(month,getdate()) as Month

Month
13

suppose current month is december,and add one month from the current month i want the output as follows,


Output i want as follows if current month is december

Month
1.


for that how can i write the sql query.

Rgds,
Narasiman P.