sql查询日期的问题！！！！！！！！！！

Question

SELECT * FROM VIEW1
WHERE datediff(day,CHECKTIME,'2006-7-27')=0

Answer 1

SELECT * FROM VIEW1 WHERE DATEDIFF(DAY,CHECKTIME,'2006-7-27')=0

Answer 2

select * from  VIEW1
where datediff(d,CHECKTIME,'2006-7-27')=0

Answer 3

SELECT * FROM VIEW1
WHERE year(CHECKTIME)= 2006 and month(CHECKTIME)=7 and day(CHECKTIME)=27

Answer 4

SELECT * FROM VIEW1
WHERE convert(varchar(8),CHECKTIME,112) = '20060727'

Answer 5

SELECT * FROM VIEW1 WHERE DATEDIFF(DAY,CHECKTIME,'2006-7-27')=0

Answer 6

SELECT * FROM VIEW1 WHERE CHECKTIME BETWEEN '2006-7-27' AND DATEADD(Millisecond,-1,'2006-07-28)

Answer 7

不好意思,少了一个引号
SELECT * FROM VIEW1 WHERE CHECKTIME BETWEEN '2006-7-27' AND DATEADD(Millisecond,-1,'2006-07-28')