try this,
Here I will find out the date after 2 days from today,
SELECT CONVERT(VARCHAR(10), GETDATE()+2, 105) AS date
--------------------------------------------------------------------------------------------------------
Updated code,
To findout the date after 10 days retrived from column 'Date' in my table Table_1,
select CONVERT(VARCHAR(10),dateadd(day,10,Date),105) as date from Table_1 where ID=1
To findout the date after 10 months retrived from column 'Date' in my table Table_1,
select CONVERT(VARCHAR(10),dateadd(month,10,Date),105) as date from Table_1 where ID=1
--------------
@Nidhish