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!