rgb192
asked on
where datetime field is less than 1 day of current datetime
where datetime field is less than 1 day of current datetime
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
test:
create table t_name (
dt datetime,
num int
)
Go
insert into t_name (dt,num)
select getdate(),0
union
select dateadd(day,-1,getdate()),
union
select dateadd(day,-2,getdate()),
SELECT *
FROM t_name
WHERE dt < DATEADD(day,-1,GETDATE())
returns
dt num
2011-03-07 12:31:50.007 2
2011-03-08 12:31:50.007 1