• Thanks for a good article. I've been using the CONVERT(CONVERT) technique mentioned by lhowe.

    lhowe (4/7/2010)


    Another method to strip the time from a date/time value and keep it as a datetime type would be: CONVERT(datetime,CONVERT(varchar,GetDate(),101))

    The value of the DADD technique is the ability to apply it to weeks, months, years.

    Thanks again!