CREATE FUNCTION dbo.fn_dayofmonth (@dt datetime)
RETURNS int AS
BEGIN
declare @nextmonth datetime
set @nextmonth=dateadd(m,1,@dt)
return(day(dateadd(day,-day(@nextmonth),@nextmonth)))
END
转载于:https://www.cnblogs.com/skyblue/archive/2007/03/14/674579.html