'>' 附近有语法错误。哪位大神能帮我看看，为什么我这错了，拜托拜托

Question

select (case when 09>convert(char(2), OperateDt,8)>18 then'白班' else '晚班' end) as OperateDt
from View_YBinBoxMain

Answer 1

select (case when convert(char(2), OperateDt,8)>9 and convert(char(2), OperateDt,8)<18 then'白班' else '晚班' end) as OperateDt
from View_YBinBoxMain
我测试过了，应该是这样的