Retrieving the Date From a SQL Server DateTime

The SQL Server DateTime and SmallDateTime data types are ideal for storing date and time information. Often you will want to extract the date part of such a value with the time part set to midnight. This article describes several ways to achieve this.