TSQL Date Only Function

by Jon Hibbins on 24 November 2009
Filed under: Code, Database, MSSQL2005, MSSQL2008, Quick Tips, Software Development, SQL Server, TSQL

CREATE FUNCTION [dbo].[DateOnly] (@DATE DATETIME)
RETURNS DATETIME
BEGIN
    RETURN DATEADD(d, DATEDIFF(d, 0, @DATE), 0)
END

Leave a Reply