SQL date part of date-time

Today I learned how to get just the date part of a date-time in SQL Server 2008 and up.

Select
    CONVERT(date, datetime_column)
    FROM table_with_datetime