sql server获取后天距离某一日期还有多少周的写法

select datediff(week,convert(varchar(20),dateadd(dd,2,getdate()),111),'2012-10-18 00:00:00.000')