select getdate() as 日期 ,
year(getdate()) as 年,
case month(getdate())
when 1 then '一月'
when 2 then '二月'
when 3 then '三月'
when 4 then '四月'
when 5 then '五月'
when 6 then '六月'
when 7 then '七月'
when 8 then '八月'
when 9 then '九月'
when 10 then '十月'
when 11 then '十一月'
when 12 then '十二月'
end as 月,
case datepart(weekday,getdate())-1
when 1 then '星期一'
when 2 then '星期二'
when 3 then '星期三'
when 4 then '星期四'
when 5 then '星期五'
when 6 then '星期六'
when 0 then '星期日'
end as 星期
,datepart(week,getdate()) as 年内的第几周
,datepart(quarter,getdate()) as 年内的第几季
温馨提示:答案为网友推荐,仅供参考