MSSQL GetDateOnly

• Function returns date part of the datetime.

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Tomas Borovicka
-- Create date: 14.4.2009
-- Description:	<Description, ,>
-- =============================================
ALTER FUNCTION [dbo].[GetDateOnly](@DATE DATETIME)
RETURNS DATETIME
AS
BEGIN
	RETURN CONVERT(datetime,CONVERT(VARCHAR(25), @DATE, 104),104)
END