set @t2 = cast('2003-09-05 15:25:36' as datetime)
set @t1 = cast(datepart(year,@t2) as char(4))
set @t4 = cast(datepart(month,@t2) as varchar(2))
set @n = len(@t4)
if(@n < 2)
set @t4 = stuff(@t4,1,0,'0')
set @t1 = @t1 + @t4
print @t1
--日,时间依次类推,就是代码多点