select * from 表 where 时间字段between LEFT(CONVERT(char(19), GETDATE(), 121), 11) + '06:00:00') AND DATEADD(dd, 2, LEFT(CONVERT(char(19), GETDATE(), 121), 11) + '06:00:00')
select * from 表 where 时间字段 between CONVERT(char(10), GETDATE(), 120)+ ' 06:00:00' AND convert(char(10),DATEADD(dd,1,getdate()),120)+ ' 06:00:00'
select * from 表 where 时间字段 between cast(CONVERT(varchar(10),getdate(),120)+' 06:00:00' as datetime) AND cast(CONVERT(varchar(10),getdate()+1,120)+' 06:00:00' as datetime)
select * from 表 where 时间字段 between CONVERT(char(10), GETDATE(), 120)+ ' 06:00:00' AND convert(char(10),DATEADD(dd,1,getdate()),120)+ ' 06:00:00'
where 时间字段 between CONVERT(char(10), GETDATE(), 120)+ ' 06:00:00'
AND convert(char(10),DATEADD(dd,1,getdate()),120)+ ' 06:00:00'
from 表
where 时间字段 between cast(CONVERT(varchar(10),getdate(),120)+' 06:00:00' as datetime)
AND cast(CONVERT(varchar(10),getdate()+1,120)+' 06:00:00' as datetime)
where 时间字段 between CONVERT(char(10), GETDATE(), 120)+ ' 06:00:00'
AND convert(char(10),DATEADD(dd,1,getdate()),120)+ ' 06:00:00'