This explains the easy way to strip time part in sql date time

If you’re like me you’ve got a whole slew of web pages that you’ve developed. That means you’ve got a lot of pages to modify every year to update the copyright to reflect the new year. Instead of hard-coding the year in to your xhtml, replace it with the following code snippet and you’re all set!...

It's all about using the right data types. Sure, there's no "date" or "time" only data type available, but that's no excuse to return VARCHAR strings formatted as dates or times instead of the correct data type: datetime.

This sample shows how to get the last day of the current week. It easily could be reconfigured to get any day of the week of any date.