日期问题请教

Question

datename(year,getdate())
+right(('00'+ltrim(convert(varchar(2),month(getdate())))),2)
+right(('00'+ltrim(convert(varchar(2),day(getdate())))),2)

Answer 1

CONVERT(varchar(10), StartDate,120)

Answer 2

STR(DATEPART(yyyy,getdate()) * 10000 + DATEPART(mm,getdate())*100+datepart(dd,getdate()))