Question:
How do I set a default for a date field having sysdate, current_date or date as the value?
Answer:
To use the current date as a default value in a date field, specify the function GETDATE() as the default. This will enter the current date and time if none is specified when a record is inserted.