sqlserver获取年份。

?select DateName(year,GetDate()) as '年';

?select GETDATE() as '当前日期',
DateName(year,GetDate()) as '年',u5b8bu4f53; line-height:20px">DateName(month,GetDate()) as '月',u5b8bu4f53; line-height:20px">DateName(day,GetDate()) as '日',u5b8bu4f53; line-height:20px">DateName(dw,GetDate()) as '星期',u5b8bu4f53; line-height:20px">DateName(week,GetDate()) as '周数',u5b8bu4f53; line-height:20px">DateName(hour,GetDate()) as '时',u5b8bu4f53; line-height:20px">DateName(minute,GetDate()) as '分',u5b8bu4f53; line-height:20px">DateName(second,GetDate()) as '秒'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!