有这样一个需求,查询当天的数据表里边有个time字段,这样改怎么查啊?select * from table where time>当天0点 and time <当天24点 网上也查了下select * from table where time BETWEEN 当天0点 and 当天24点 但是具体怎么做就不知道了那位帮忙说下,谢谢。
select * from table where datediff(day,[time],getdate())
select * from table where datediff(dd , time , getdate()) = 0select * from table where convert(varchar(10),time,120) = convert(varchar(10),getdate(),120)
select * from table where datediff(day,[time],getdate())
select * from table where datediff(day,[time],getdate()) = 0
select * from table where datediff(dd,time,getdate()) = 0
select * from table where datediff(minute,[time],cast((Convert(varchar(10),getdate(),120)+' 00:00:00')as datetime))<=0 ANd datediff(minute,[time],cast((Convert(varchar(10),getdate(),120)+' 23:59:59')as datetime))>=0
select * from tb where datediff(dd,time,getdate()) = 0
where datediff(day,[time],getdate())
where datediff(day,[time],getdate())
select * from table
where datediff(day,[time],getdate()) = 0
select * from
table
where
datediff(minute,[time],cast((Convert(varchar(10),getdate(),120)+' 00:00:00')as datetime))<=0
ANd
datediff(minute,[time],cast((Convert(varchar(10),getdate(),120)+' 23:59:59')as datetime))>=0