Manipulating Dates

You can do some arithmetic calculations on date and time datatypes values with the built-in date functions.

See Transact-SQL Users Guide.