22,209
社区成员
发帖
与我相关
我的任务
分享
create table test(crdate datetime)
go
insert into test
select dateadd(MI, number * 5, '2018-04-20')
from master..spt_values
where type = 'p' and number < = 1440 / 5
go
select crdate,
case when right(convert(varchar(16), crdate, 121), 5) between '08:30' and '20:00' then '白' else '夜' end
from test
go
drop table test
go
SELECT CASE
WHEN CONVERT(VARCHAR, GETDATE(), 8) > '08:30'
AND CONVERT(VARCHAR, GETDATE(), 8) < '20:30' THEN
'白班'
ELSE
'夜班'
END AS 测试1,
CASE
WHEN CONVERT(VARCHAR, DATEADD(HOUR,2,GETDATE()), 8) > '08:30'
AND CONVERT(VARCHAR, DATEADD(HOUR,2,GETDATE()), 8) < '20:30' THEN
'白班'
ELSE
'夜班'
END AS 测试2