This blog shows how to do an increase a date value to 10 days in the output using SQL Query

Example:

SELECT DATEADD(d, 10, '2/2/2011')

The expected result would be 2011-02-12 00:00:00.000