• Thanks for the question.

    The default value for the @date1 is NULL.

    Please see below proof. If I am commenting the 'set statement, I am getting @date1 as NULL.

    declare @date1 smalldatetime

    --set @date1 = 0

    print Isnull(@date1,getdate())

    Thanks.

    Reji P R

    Hyderabad

    Thanks.

    Reji PR,
    Bangalore
    😀