Delete donde compara un Date dentro de un DateTime ignorando el valor del tiempo.
Delete from NucVehiculo where CAST('2019-12-19' AS DATE) = CAST(CreationDate AS DATE)