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() ) )
