ASA SQL User's Guide
Ensuring Data Integrity
Using column defaults
You can use a constant expression as a default value, as long as it does not reference database objects. Constant expressions allow column defaults to contain entries such as the date fifteen days from today , which would be entered as
... DEFAULT ( dateadd( day, 15, getdate() ) )