SELECT DATENAME(mm, getdate()) AS 'Month Name'
结果:
Month Name
------------------------------
December(1 row(s) affected)我得到的是月份的全称啊?
结果:
Month Name
------------------------------
December(1 row(s) affected)我得到的是月份的全称啊?
此示例从 GETDATE 返回的日期中提取月份名。这个是v2000的例子:
SELECT DATENAME(month, getdate()) AS 'Month Name'下面是结果集:Month Name
------------------------------
February