ALTER function [dbo].[GetStageByDay](@BabyBirthday date,@nowDate date)
returns nvarchar(5)
as
begin
declare @Stage nvarchar(5),@daySum int
set @daySum=datediff(day,@BabyBirthday,@nowDate)
set @Stage=(case when @daySum<0 and @daySum>=-90 then 'T3'
when @daySum<-90 and @daySum>=-180 then 'T2'
when @daySum<-180 and @daySum>=-277 then 'T1'
when @daySum>=0 and @daySum<=182 then 'S1'
when @daySum>182 and @daySum<=365 then 'S2'
when @daySum>365 and @daySum<=1095 then 'S3'
when @daySum>1095 and @daySum<=2190 then 'S4'
else 'other' end)
return @Stage
end
将 sql server中的function函数转化为mysql的格式 请各位大佬指点一下
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
- BLOB_101001 2020-11-25 16:35关注
begin
declare Stage varchar(16);declare daySum int;
set daySum=datediff(nowDate,BabyBirthday);
select (case when daySum<0 and daySum>=-90 then 'T3'
when daySum<-90 and daySum>=-180 then 'T2'
when daySum<-180 and daySum>=-277 then 'T1'
when daySum>=0 and daySum<=182 then 'S1'
when daySum>182 and daySum<=365 then 'S2'
when daySum>365 and daySum<=1095 then 'S3'
when daySum>1095 and daySum<=2190 then 'S4'
else 'other' end) into Stage;
return Stage;
end解决 无用评论 打赏 举报
悬赏问题
- ¥15 很想要一个很好的答案或提示
- ¥15 扫描项目中发现AndroidOS.Agent、Android/SmsThief.LI!tr
- ¥15 怀疑手机被监控,请问怎么解决和防止
- ¥15 Qt下使用tcp获取数据的详细操作
- ¥15 idea右下角设置编码是灰色的
- ¥15 全志H618ROM新增分区
- ¥15 在grasshopper里DrawViewportWires更改预览后,禁用电池仍然显示
- ¥15 NAO机器人的录音程序保存问题
- ¥15 C#读写EXCEL文件,不同编译
- ¥15 MapReduce结果输出到HBase,一直连接不上MySQL