今天抓紧时间:
SELECT dateadd(day,datediff(day,0,GETDATE()),0)
昨天没有时间:
SELECT dateadd(day,datediff(day,1,GETDATE()),0)
查询昨天的所有行:
select
*
from yourTable
WHERE YourDate >= dateadd(day,datediff(day,1,GETDATE()),0)
AND YourDate < dateadd(day,datediff(day,0,GETDATE()),0)