取当前的日期,结果显示为:2009年12月09日
select cast(year(getdate()) as char(4))+'年'+cast(month(getdate()) as char(2))+'月'+cast(day(getdate()) as char(2))+'日'
select cast(year(getdate()) as char(4))+'年'+cast(month(getdate()) as char(2))+'月'+cast(day(getdate()) as char(2))+'日'