select * from tablename cast(datepart(hh,getdate()) as varchar(2)) +':'+ cast(datepart(mi,getdate()) as varchar(2))>'11:30'
在此說明一下datepart的用法 DATEPART ( datepart , date ) Datepart Abbreviations year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww weekday dw hour hh minute mi, n second ss, s millisecond ms
然后对转换后的字符串截取时间部分。
然后再作判断。
cast(datepart(hh,getdate()) as varchar(2)) +':'+
cast(datepart(mi,getdate()) as varchar(2))>'11:30'
DATEPART ( datepart , date )
Datepart Abbreviations
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
weekday dw
hour hh
minute mi, n
second ss, s
millisecond ms