select *
from tb
where (convert(time,列名) between '05:30:00' and '12:36:00') or
(convert(time,列名) between '14:35:00' and '19:32:00')
from tb
where (convert(time,列名) between '05:30:00' and '12:36:00') or
(convert(time,列名) between '14:35:00' and '19:32:00')
select *
from 表名
where (convert(varchar(12),字段名,108) between '05:30:00' and '12:36:00') or
(convert(varchar(12),字段名,108) between '14:35:00' and '19:32:00')
这个应该也可以
select *
from 表名
where convert(char(5),字段名,108) between '05:30' and '12:36' or
convert(char(5),字段名,108) between '14:35' and '19:32'
from 表名
where (convert(varchar(19),字段名,120) between convert(varchar(10),GETDATE(),120)+' 05:30:00' and convert(varchar(10),GETDATE(),120)+' 12:36:00') or
(convert(varchar(19),字段名,120) between convert(varchar(10),GETDATE(),120)+' 14:35:00' and convert(varchar(10),GETDATE(),120)+' 19:32:00')