1. select * from tablename where datediff(day,SendTime,'2006-06-30')=02. select * from tablename where SendTime between '2006-06-30 08:01:01' and '2006-06-30 13:59:59' 3. 上次查询时间你从哪里获得?4. 不会
1.查询2006-06-30号这天发布的记录,应该怎么写 select * from 表 where datediff(day,SendTime,'2006-06-30')=0 2.查询2006-06-30 08:01:01 到2006-06-30 13:59:59这段时间发布的记录又要怎么写 select * from 表 where SendTime between '2006-06-30 08:01:01' and '2006-06-30 13:59:59' 3.查询从上次查询之后到此次查询,这段时间里发布的数据 select * from 表 where SendTime between 上次查询时间 and '2006-06-30 13:59:59'
3.查询从上次查询之后到此次查询,这段时间里发布的数据 select * from 表 where SendTime between 上次查询时间 and Getdate()
1.select * from tb where sendtime='2006-06-30' 2.select * from tb where sendtime between '2006-06-30 08:01:01' and '2006-06-30 13:59:59' 3.--先前查询 declare @dt1 datetime select @dt1=getdate() ...--中间的查询动作 --次后的查询 declare @dt2 datetime select @d2=getdate() select * from tb where sendtime between @dt1 and @dt2
select * from 表 where datediff(day,SendTime,'2006-06-30')=0
2.查询2006-06-30 08:01:01 到2006-06-30 13:59:59这段时间发布的记录又要怎么写
select * from 表 where SendTime between '2006-06-30 08:01:01' and '2006-06-30 13:59:59'
3.查询从上次查询之后到此次查询,这段时间里发布的数据
select * from 表 where SendTime between 上次查询时间 and '2006-06-30 13:59:59'
select * from 表 where SendTime between 上次查询时间 and Getdate()
2.select * from tb where sendtime between '2006-06-30 08:01:01' and '2006-06-30 13:59:59'
3.--先前查询
declare @dt1 datetime
select @dt1=getdate()
...--中间的查询动作 --次后的查询
declare @dt2 datetime
select @d2=getdate()
select * from tb where sendtime between @dt1 and @dt2