create function fn_getLastDayOfMonth
(
@inputTime datetime
)
returns datetime
AS
begin
declare @inday int
declare @dtmDateNew datetime
--取输入日期所在月份的第几天
set @inday=day(@inputTime)
--获得这个月的第一天
set @dtmDateNew=DateAdd(day,-@inday+1,@inputTime)
--获得下个月的第一天
set @dtmDateNew=DateAdd(month,1,@dtmDateNew)
--减一天即为本月最后一天
set @dtmDateNew=DateAdd(day,-1,@dtmDateNew)
return(@dtmDateNew)
end
select dbo.fn_getlastdayofmonth('2007-2-3')