• Best way to determine this is to setup a test environment and do it both ways. Using a default will alleviate the need for the developers to code for inserting the current date

    Just remember, a default is only used if the column isn't included in the INSERT. If it is included and an invalid or simply incorrect date (including NULL if permitted) will prevent the DEFAULT from being inserted.