求一个简单的时间查询~~~

yowbell 2008-01-10 11:44:47





时间戳                

------------------ 

01  1 2008  6:00AM

01  2 2008  6:00AM

01  3 2008  6:00AM

01  4 2008  6:00AM

01  5 2008  6:00AM

01  6 2008  6:00AM

01  7 2008  6:00AM

01  8 2008  6:00AM

01  9 2008  6:00AM

01 10 2008  6:00AM

12 29 2007  6:00AM

12 30 2007  6:00AM

12 31 2007  6:00AM



如何查出二天前的记录？

...全文

86 7 打赏收藏举报

写回复

7 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

yowbell 2008-01-13

感谢各位~~

打赏
举报

回复赞

pt1314917 2008-01-10



这样？

select * from @t where datediff(dd,time,getdate())>2

打赏
举报

回复赞

chuifengde 2008-01-10

select * from [Table] where dateadd(day,2,时间戳)<getdate()

打赏
举报

回复赞

zywinner168 2008-01-10

学习

打赏
举报

回复赞

shirley_yue 2008-01-10

够细的哦

打赏
举报

回复赞

dawugui 2008-01-10

时间戳
------------------
01 1 2008 6:00AM
01 2 2008 6:00AM
01 3 2008 6:00AM
01 4 2008 6:00AM
01 5 2008 6:00AM
01 6 2008 6:00AM
01 7 2008 6:00AM
01 8 2008 6:00AM
01 9 2008 6:00AM
01 10 2008 6:00AM
12 29 2007 6:00AM
12 30 2007 6:00AM
12 31 2007 6:00AM

如何查出二天前的记录？

--两天前

select * from tb where datediff(day,2,时间戳) >= 2

--48小时前

select * from tb where datediff(hour,48,时间戳) >= 48

打赏
举报

回复赞

JL99000 2008-01-10

if object_id('tb') is not null
drop table tb
go
create table tb(时间戳 datetime)
insert tb
select '01 1 2008 6:00AM' union all
select '01 2 2008 6:00AM' union all
select '01 3 2008 6:00AM' union all
select '01 4 2008 6:00AM' union all
select '01 5 2008 6:00AM' union all
select '01 6 2008 6:00AM' union all
select '01 7 2008 6:00AM' union all
select '01 8 2008 6:00AM' union all
select '01 9 2008 6:00AM' union all
select '01 10 2008 6:00AM' union all
select '12 29 2007 6:00AM' union all
select '12 30 2007 6:00AM' union all
select '12 31 2007 6:00AM'
select * from tb
select * from tb where dateadd(day,2,时间戳)<getdate()