34,575
社区成员
发帖
与我相关
我的任务
分享
--解决闰年2月29日转换报错问题
if(datepart(mm,getdate())='2' and datepart(dd,getdate())='29')
begin
select * from client c
where datediff(dd, cast(rtrim(datepart(yy,c.ContactBrithday))+'-'+
rtrim(datepart(mm,getdate()))+'-'+
rtrim(datepart(dd,getdate())-1) as datetime),c.ContactBrithday) between 0 And 5
end
else
begin
select * from client c
where datediff(dd, cast(rtrim(datepart(yy,c.ContactBrithday))+'-'+
rtrim(datepart(mm,getdate()))+'-'+
rtrim(datepart(dd,getdate())) as datetime),c.ContactBrithday) between 0 And 5
or
--解决跨年问题
datediff(dd, cast(rtrim(datepart(yy,c.ContactBrithday)-1)+'-'+
rtrim(datepart(mm,getdate()))+'-'+
rtrim(datepart(dd,getdate())) as datetime),c.ContactBrithday) between 0 And 5
end