A common function that people need to do when dealing with datetimes is extracting the date from the datetime. Oracle has a built-in function to do this called TRUNC. SQL Server does not have this (yet). However… you can accomplish this very easily. Here are a few ways to perform a truncate date function in SQL Server.
-- Assign date to variable
DECLARE @DateToTruncate DATETIME = '2014-08-01 14:12:34'
-- Get the date using casts
SELECT CAST(CAST(@DateToTruncate AS DATE) AS DATETIME)
-- Get the date using convert
SELECT CAST(CONVERT(VARCHAR(10), @DateToTruncate, 101) AS DATETIME)