SQL Server : create future dates -

how create future dates in sql? example, want able use date range , show next month (purchase orders), 2 months out, etc. have used fn now() current date/time doesn't me @ showing records next month, etc.

thanks

this sql query in doing in sql server 2008 r2.

if use mysql can use:

select date_col your_table date_col between now() , date_add(now(), interval 1 month) 

for ms-sql (it should work):

select date_col your_table date_col between getdate() , dateadd(month, 1, getdate()) 

for oracle (it should work):

select date_col your_table date_col between sysdate , add_months(sysdate, 1)