/*返回最后一天*/
create function uf_LastDay( @date datetime)
returns int
as
begin
declare @year int, @Month int,@day int,@lastday int
select @year=datepart(year,@date),@month=datepart(month,@date),@day=datepart(day,@date),@lastday=0
if @year%100=0
begin
if @year%400=0 set @lastday=1
end
else
begin
if @year%4=0 set @lastday=1
end
if @month in (1,3,5,7,8,10,12)
set @lastday=31
else if @month in (4,6,8,9,11)
set @lastday=30
else set @lastday=@lastday+28
return @lastday
end
如果你使用的是 SQL Server 2000
可以先生成这样一个函数
/*返回最后一天*/
create function uf_LastDay( @date datetime)
returns int
as
begin
declare @year int, @Month int,@day int,@lastday int
select @year=datepart(year,@date),@month=datepart(month,@date),@day=datepart(day,@date),@lastday=0
if @year%100=0
begin
if @year%400=0 set @lastday=1
end
else
begin
if @year%4=0 set @lastday=1
end
if @month in (1,3,5,7,8,10,12)
set @lastday=31
else if @month in (4,6,8,9,11)
set @lastday=30
else set @lastday=@lastday+28
return @lastday
end
如果你使用的是 SQL Server 2000
可以先生成这样一个函数