create table #t(timeA datetime,content char(10))
goinsert into #t(timeA, content) values('2006-01-01','aa')
insert into #t(timeA, content) values('2006-01-15','bb')
insert into #t(timeA, content) values(getdate()-4,'cc')
insert into #t(timeA, content) values(dateadd(ss,-3,getdate()),'dd')
insert into #t(timeA, content) values(dateadd(ss,-2,getdate()),'ee')
insert into #t(timeA, content) values(dateadd(ss,-1,getdate()),'ff')select * from #t--返回时间不小于当前系统时间3秒的记录
select * from #t where datediff(ss,timeA,getdate())<=3drop table #t
goinsert into #t(timeA, content) values('2006-01-01','aa')
insert into #t(timeA, content) values('2006-01-15','bb')
insert into #t(timeA, content) values(getdate()-4,'cc')
insert into #t(timeA, content) values(dateadd(ss,-3,getdate()),'dd')
insert into #t(timeA, content) values(dateadd(ss,-2,getdate()),'ee')
insert into #t(timeA, content) values(dateadd(ss,-1,getdate()),'ff')select * from #t--返回时间不小于当前系统时间3秒的记录
select * from #t where datediff(ss,timeA,getdate())<=3drop table #t
解决方案 »
- 如何把查询结果放到表里
- SQL的查询不是很明白想请教一下~~~~
- 没注册成功的实例怎样删除啊,怎么一点就连接?
- 请教sql统计语句【换个排序方式】
- ~~~~如何在SQL Server内获取客户端的IP地址
- SQL语句?
- 关于一个SQL语句 的写法
- 关于建立数据库的问题,十万火急,高手帮帮忙
- 触发器如何做到高实时性?
- 安装CMS 提示access denied for user odbc@localhost(using password:no)
- count(*)达到300多万条的时候会很慢......,请问用存储过程怎么写!
- 大家好,我这里有几个存储过程里的常用语句,请大家帮忙解释一下,谢谢大家
select * from 表 where datediff(ss,getdate(),timeA)>=3