How to get month name from date in Sql Server(如何从时间中获取月份名称)

最新推荐文章于 2023-03-25 18:11:29 发布

jiatongtong

最新推荐文章于 2023-03-25 18:11:29 发布

阅读量806

点赞数

分类专栏： SQL SERVER 数据库文章标签： sqlserver datename language

SQL SERVER 数据库专栏收录该内容

85 篇文章 1 订阅

订阅专栏

如果想要月份的英文名字，只需要使用：

 
 SET 
 LANGUAGE English 

 
 SELECT 
 DATENAME(mm, GETDATE())  
 'English Month Name' 

June 7, 2015 Sql Server convert date to month name, DATENAME, DateName for Month Name, DATENAME function, FORMAT, FORMAT function, Month name from date, Month name from date in sql, Monthname from date, Monthname from datetime, Sql, Sql Server Basavaraj Biradar

Many a times we come across a scenario where we may need to get Month name from Date in Sql Server. In this article we will see how we can get Month name from Date in Sql Server.

Approach 1: Using DATENAME Function

We can use DATENAME() function to get Month name from Date in Sql Server, here we need specify datepart parameter of the DATENAME function as month or mm or m all will return the same result.

 
    
         SELECT 
         GETDATE()  
         'Today' 
         , DATENAME( 
         month 
         ,GETDATE())  
         'Month Name' 
        
 
         SELECT 
         GetDate()  
         'Today' 
         , DATENAME(mm,GETDATE())  
         'Month Name' 
        
 
         SELECT 
         GetDate()  
         'Today' 
         , DATENAME(m,GETDATE())  
         'Month Name' 
        
 
  

RESULT:

If you need result in different language than the default one, then we need to use the SET LANGUAGE statement to change the Sql Server default language for the current session. Below example shows how we can get the Month name in Russian from Date.

 
         --Change default langauage to Russian for this session 
        
         SET LANGUAGE Russian 
        
         SELECT 
         DATENAME(mm, GETDATE())  
         'Russian Month Name' 
        
         --Change the language back to English from Arabic 
        
         SET 
         LANGUAGE English 
        
         SELECT 
         DATENAME(mm, GETDATE())  
         'English Month Name'

RESULT:

The sys.syslanguages catalog view provides the list of languages to which we can change the current sessions language using SET LANGUAGE statement.

Approach 2: Using FORMAT Function

We can aswell use FORMAT function which is introduced in Sql Server 2012 to get Month name from Date in Sql Server. It is not an Sql Server native function instead it is .NET CLR dependent function. I would prefer the first approach instead of this approach for getting Month name from Date in Sql Server. But FORMAT function provides lot of options compared to DATENAME function. To know more on FORMAT function you may like to go through a detailed article on FORMAT STRING FUNCTION IN SQL SERVER 2012 which I have written couple of years back.

 
         SELECT 
         GETDATE()  
         'Today' 
         , FORMAT(GETDATE(), 
         'MMMM' 
         )  
         'Month Name'

RESULT