查询日期

Question

数据库里字段:    publishTime 2010-08-24 16:06:30.0002010-08-24 16:06:33.0002010-08-24 17:06:30.000现在要查出 2010-08-24 这天的数据，也就是不管时间是多少，日期只要准确就行
select * from YSBiz10_Fct_BizInfo  where PublishTime like  '2010%' 
select * from YSBiz10_Fct_BizInfo  where PublishTime like  convert(varchar(10),getdate(),120)
以上sql语句不对
请问怎么做

Answer 1

select datediff(d,'2010-08-24 16:06:30.000','2010-08-24') 结果为0所以可以用select * from YSBiz10_Fct_BizInfo  where datediff(d,publishtime,'2010-08-24')=0这条语句来查。

Answer 2

Select CONVERT(varchar(100), GETDATE(), 23)--结果
2010-08-24

Answer 3

where convert(varchar(10),getdate(),120) like ''+convert(varchar(10),getdate(),120)+'%'

Answer 4

where convert(varchar(10),PublishTime ,120) like ''+convert(varchar(10),getdate(),120)+'%'

Answer 5

很简单的嘛，可以试试我的，
SELECT * FROM YSBiz10_Fct_BizInfo WHERE CONVERT(varchar(10),PublishTime,112)='20100824'或者是：
SELECT * FROM YSBiz10_Fct_BizInfo WHERE CONVERT(varchar(10),PublishTime,121)='2010-08-24'

Answer 6

select * from YSBiz10_Fct_BizInfo 
where CONVERT(VARCHAR(10),PublishTime,120)='2010-08-24'

Answer 7

select * from YSBiz10_Fct_BizInfo  
where CONVERT(VARCHAR(10),PublishTime,120)='2010-08-24'

Answer 8

select * from YSBiz10_Fct_BizInfo where PublishTime>='2010-08-24'  and PublishTime<='2010-08-25'

Answer 9

直接用convert函数就可以，代码如下：select * from YSBiz10_Fct_BizInfo where convert(varchar(10),PublishTime,120)='2010-08-24'

Answer 10

select * from YSBiz10_Fct_BizInfo where convert(varchar(100),PublishTime,23)='2010-08-24'
试试看