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