DATENAME(MONTH,GETADATE())返回月份的数字值为'09' [英] DATENAME(MONTH,GETADATE()) is returning numeric value of the month as '09'
本文介绍了DATENAME(MONTH,GETADATE())返回月份的数字值为'09'的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我运行以下查询[SELECT DATENAME(MONTH,GETDATE())]时,理想情况下,它的返回值应为'September',但其返回值应为'09'.我正在MS SQL Server 2005上运行此查询.我需要使用MS SQL Server 2005进行配置吗?
When I run the following query [SELECT DATENAME(MONTH,GETDATE())], ideally speaking it should return value as 'September' but its returning value as '09'. I am running this query on MS SQL Server 2005. Is there anything I need to configure with MS SQL Server 2005?
请找到SQL Server 2005的详细信息
Please find the details of the SQL Server 2005
Component Name Version
--------------------------------------------------------------------
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
推荐答案
SELECT @@LANGUAGE -> gives an Asian one?
SET LANGUAGE Japanese
SELECT DATENAME (month, GETDATE())
SET LANGUAGE us_english
SELECT DATENAME (month, GETDATE())
DATENAME 取决于语言,因此需要更改服务器默认值或您的登录默认语言...
DATENAME depends on language, so need to change server default or your login default language...
谢谢你和sayonara ...
Thank you and sayonara...
这篇关于DATENAME(MONTH,GETADATE())返回月份的数字值为'09'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文