27,580
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([合同ID] nvarchar(21),[到期日期] Date)
Insert #T
select N'A','2018/6/10' union all
select N'B','2018/6/1' union all
select N'C','2018/6/20' union all
select N'D','2018/7/10' union all
select N'E','2018/8/1' union all
select N'F','2018/5/25'
Go
--测试数据结束
SELECT *,
CASE
WHEN DATEDIFF(DAY, GETDATE(), 到期日期) < 0 THEN
'过期未签'
WHEN DATEDIFF(DAY, GETDATE(), 到期日期) = 0 THEN
'今天'
WHEN DATEDIFF(DAY, GETDATE(), 到期日期) > 0
AND DATEDIFF(DAY, GETDATE(), 到期日期) < 7 THEN
'七天内'
WHEN DATEDIFF(DAY, GETDATE(), 到期日期) > 7
AND DATEDIFF(DAY, GETDATE(), 到期日期) <= 30 THEN
'30天内'
ELSE
'30天后'
END
FROM #T;