Constant Expression Defaults

You can use a constant expression as a default value, as long as the expression does not reference database objects.

Functions such as GETDATE and DATEADD can be used in a constant expression default value. If the default constant expression is not a function or simple value, the expression must be enclosed in parentheses.

For example, constant expressions allow column defaults to contain entries such as the date fifteen days from today:

... DEFAULT ( DATEADD( DAY, 15, GETDATE() ) )