• SELECT CAST(0 AS DATETIME)

    Resolves to

    1900-01-01 00:00:00.000

    (DT_DBDATE)0

    Resolves to

    1899-12-30

    There's your two days difference