Assuming table1 as table and col1 as column

declare @yesterday datetime
SELECT @yesterday=DATEADD(millisecond,DATEDIFF(millisecond, 0, (SELECT 
                  CONVERT(TIME,'22:00:00.000')) ),CAST( (convert(date, 
                  dateadd(day,datediff(day,1, GETDATE()),0)))  AS DATETIME));

declare @daybeforeyesterday datetime
SELECT @daybeforeyesterday=DATEADD(millisecond
                           ,DATEDIFF(millisecond, 0, (SELECT CONVERT(TIME,'22:00:00.000')) 
                           ),CAST( (convert(date, dateadd(day,datediff(day,2, 
                           GETDATE()),0)))  AS DATETIME));

select * from table1 where col1 between @yesterday and @daybeforeyesterday

只需使用 Date() （从午夜开始，'00:00:00'）和 CDate （请注意，对于相同的值，时间格式可能不同，例如。， 10 PM 与 22:00 ).

SELECT ...
FROM myTable
WHERE myDate BETWEEN (Date() - 2) + CDate('10 PM')
                 AND (Date() - 1) + CDate('22:00')

计算小时数差异并使用日期添加：

Select *
From YourTable
Where YourDateField Between
    DateAdd("h", -26, Date()) And DateAdd("h", -2, Date())