SQL中datetime（查询器里显示2008-07-04 13:59:00.000）怎么按日期查询

Question

SQL中datetime（查询器里显示2008-07-04 13:59:00.000）怎么按日期查询，直接日期去匹配

Answer 1

select * from 表 where datediff(day,日期,'2008-07-04')=0

Answer 2

declare @myday datetimeselect * from 表 
where convert(nvarchar,myday,120) = convert(nvarchar,@myday,120)

Answer 3

declare @myday datetime
set @myday ='2008-07-04 13:59:00.000'select * from 表 
where convert(nvarchar,myday,120) = convert(nvarchar,@myday,120)

Answer 4

select * from 表 where convert(varchar(10),日期,120)='2008-07-04'

Answer 5

select * from 表 
where convert(nvarchar(10),DateCol,120) = '2008-09-25'

Answer 6

insert tb(a)
select a from tb where convert(nvarchar(10),日期字段,120) = '2008-09-25'

Answer 7

select * 
from tb
where convert(varchar(10),col)='2008-07-04'

Answer 8

select * from tb where convert(varchar(10),日期字段,120)='2008-07-04'

Answer 9

select * from EL_PickListTable  where UploadDate='2011-07-25 15:02:52.017' 这样直接写也可以嘛