SET DATEFIRST 1
SELECT SUBSTRING(CONVERT(VARCHAR(10),GETDATE(),120),3,2)+
               RIGHT('00'+RTRIM(DATEPART(WK,GETDATE())),2)+
               RTRIM(DATEPART(DW,GETDATE()))

------解决方案--------------------

SQL code
declare @dt datetime
set @dt='2009-01-08 10:56:17.123'
select right(ltrim(year(@dt)),2)+right('0'+ltrim(datepart(week,@dt)),2)+right('0'+ltrim(datepart(dw,@dt)-1),2)
/*             
------------ 
090204*/

------解决方案--------------------
探讨

SQL codedeclare @dt datetime
set @dt='2009-01-08 10:56:17.123'
select right(ltrim(year(@dt)),2)+right('0'+ltrim(datepart(week,@dt)),2)+right('0'+ltrim(datepart(dw,@dt)-1),2)
/*             
------------ 
090204*/