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