• Won't this work as well?

    AND CONVERT(DATE, P.modify_date) = @sdtInputDate