取得日期为当天的数据

 -------取得日期为当天的数据

declare @t table (id int,time datetime)
insert into @t
select 1,'2007-07-02 09:00:00'
union all
select 1,'2007-07-03 09:00:00'
union all
select 1,'2007-07-04 09:00:00'
union all
select 2,'2007-07-04 10:00:00'

--1.取当天的:
select *  from @t  where datediff(day,time,getdate())=0

--2.取前一天的:
select *  from @t  where datediff(day,time,getdate())=1

/*
id                      time
-----------------------------------------------------
1 2007-07-04 09:00:00.000
2 2007-07-04 10:00:00.000

id                       time
----------------------------------------------------
1 2007-07-03 09:00:00.000
*/