• Nice question. The explanation could be a bit more clear.

    It's not the default from the default expression GETDATE(), but the default value that is chosen when 0 or space is converted to a datetime.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP