MS SQL: Date portion from DateTime

To return only the date portion of a DateTime variable, you need to use a combination of the dateadd and datediff functions in Transact-SQL.

-- Returns @DateTime at midnight; i.e., it removes the time portion of a DateTime value.

CREATE  function [dbo].[sudf_Common_DateOnly]

(

@dtDateTime DateTime

)

returns datetime

as

begin

      -- Get the date only

    return dateadd(dd, 0, datediff(dd, 0, @dtDateTime))

end