弱弱的问一个问题!!
select Convert(int,Convert(varchar,Year('2010-5-1')) + Convert(varchar,DatePart(ww,'2010-2-1'))) as YearWeek/*
查询结果 20106
*/select Convert(int,Convert(varchar,Year('2010-5-1')) + Convert(varchar,DatePart(ww,'2010-5-1'))) as YearWeek/*
查询结果 201018
*/我要上面的查询结果像这样,201006 有什么办法实现么?
select Convert(int,Convert(varchar,Year('2010-5-1')) + Convert(varchar,DatePart(ww,'2010-2-1'))) as YearWeek/*
查询结果 20106
*/select Convert(int,Convert(varchar,Year('2010-5-1')) + Convert(varchar,DatePart(ww,'2010-5-1'))) as YearWeek/*
查询结果 201018
*/我要上面的查询结果像这样,201006 有什么办法实现么?
select convert(varchar(6), convert(datetime,'2010-5-1'), 112) -- 201005 / YYYYMM--这个我不知道你要干嘛
select datename(year,'2010-5-1') + right('00'+ltrim(datepart(ww,'2010-2-1')),2)
--自己在改改,你前面的语句调试有问题
+ RIGHT('00'+Convert(varchar,DatePart(ww,'2010-2-1')),2)
--201006