Jueves, 30 Enero 2014 12:04

Last Day of the previous month

Share this post

Get the last day of the previous month

CREATE FUNCTION [dbo].[udf_GetLastDayOfPreviousMonth]
	-- Add the parameters for the function here
	@Date datetime
RETURNS datetime
	-- Declare the return variable here
	DECLARE @ResultVar datetime

	-- Add the T-SQL statements to compute the return value here
	SELECT @ResultVar = CONVERT(VARCHAR(10),DATEADD(dd,-(DAY(@Date)),@Date),120)

	-- Return the result of the function
	RETURN @ResultVar


Visto 18915 veces Modificado por última vez en Jueves, 30 Enero 2014 12:04