«
»


TSQL Last Day Of The Month

by Jon Hibbins on 23 November 2009
Filed under: Code, MSSQL2005, MSSQL2008, Quick Tips, SQL Server, TSQL

CREATE FUNCTION [dbo].[LastDayOfTheMonth] (@Date DATETIME )
RETURNS DATETIME
BEGIN
    RETURN dateadd(ms, -3, DATEADD(mm, DATEDIFF(m, 0, @Date) + 1, 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.

Leave a Reply