select * from 表 where datediff(week,convent(datetime(8), imonth+'-'+iday+'-'+iyear,110)=0为什么会出错?
select * from 表 where datepart(week,convent(datetime(8), imonth+'-'+iday+'-'+iyear,110)=datepart(week,getdate())
select * from 表 where datediff(week,convent(datetime(8), imonth+'-'+iday+'-'+iyear,110),getdate())=0
select * from 表 where datediff(week,convent(datetime(8), cast(imonth as char(4))+'-'+cast(iday as char(2))+'-'+cast(iyear as char(2)),110)=0
select * from testtime where datediff(week,cast((cast(iyear as char(4))+'-'+cast(imonth as char(2)) +'-'+cast(iday as char(2)))as datetime), getdate())=0
select * from testtime where datediff(day,cast((cast(iyear as char(4))+'-'+cast(imonth as char(2)) +'-'+cast(iday as char(2)))as datetime), getdate())<=7
datediff(week,cast((cast(iyear as char(4))+'-'+cast(imonth as char(2))
+'-'+cast(iday as char(2)))as datetime),
getdate())=0
+'-'+cast(iday as char(2)))as datetime),
getdate())<=7