这个语句怎么会出错的：：：：又是语法!

[deadrock]

select count(*) as late_count from hr_timebook where employee_id=25 and datediff(day,2001-08-09,2001-01-09) and (cast(datename(hh,2001-01-09)as int)>8 or (cast(datename(hh,2001-01-09)as int)=8 and cast(datename(mi,2001-01-09)as int)>30))？？？？？？？？？？？？？？？？？？
是语法!
我还是看不出来啊

[chump]

datediff(day,2001-08-09,2001-01-09) 的条件呢？

[hydnoahark]

datediff中少了'（单引号）
select count(*) as late_count from hr_timebook where employee_id=25 and datediff(day,'2001-08-09','2001-01-09') and (cast(datename(hh,'2001-01-09')as int)>8 or (cast(datename(hh,'2001-01-09')as int)=8 and cast(datename(mi,'2001-01-09')as int)>30))