hibbins.com

T-SQL Date Only Function

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

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.