select DateName(year,GetDate()) as '年',
select DateName(month,GetDate()) as '月',select DateName(day,GetDate()) as '日',
select DateName(dw,GetDate()) as '星期',
select DateName(week,GetDate()) as '周数',
select DateName(hour,GetDate()) as '时',
select DateName(minute,GetDate()) as '分',
select DateName(second,GetDate()) as '秒'