{"id":1387,"date":"2019-02-27T10:16:10","date_gmt":"2019-02-27T03:16:10","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=1387"},"modified":"2020-04-11T20:12:44","modified_gmt":"2020-04-11T13:12:44","slug":"sql-server-month-function","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-date-functions\/sql-server-month-function\/","title":{"rendered":"SQL Server MONTH Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQL Server MONTH()<\/code> function to extract the month from a date.<\/p>\n\n\n\n

SQL Server MONTH() function overview #<\/a><\/h2>\n\n\n\n

The MONTH()<\/code> function returns an integer value which represents the month of a specified date.<\/p>\n\n\n\n

The following shows the syntax of the MONTH()<\/code> function:<\/p>\n\n\n

MONTH(input_date)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The MONTH()<\/code> function returns the same value as the following DATEPART()<\/a><\/code> function:<\/p>\n\n\n
DATEPART(month,input_date)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SQL Server MONTH() function examples #<\/a><\/h2>\n\n\n\n
A) Using MONTH() function with a literal date value #<\/a><\/h3>\n\n\n\n
This example uses the MONTH()<\/code> function to extract a month from the date '2020-12-01'<\/code>:<\/p>\n\n\n
SELECT<\/span> \n\tMONTH<\/span>('2020-12-01'<\/span>) [month<\/span>];\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n\n
month\n-----------\n12\n\n(1 row affected)\n<\/code><\/pre>\n\n\n\n
B) Using MONTH() function with a date value that has only time data #<\/a><\/h3>\n\n\n\n
The MONTH()<\/code> function will return 1 if the date value contains only time part:<\/p>\n\n\n
SELECT<\/span> \n\tMONTH<\/span>('15:30:20'<\/span>) [month<\/span>];\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output is as follows:<\/p>\n\n\n\n
month\n-----------\n1\n\n(1 row affected)\n<\/code><\/pre>\n\n\n\n
C) Using MONTH() function with table columns example #<\/a><\/h3>\n\n\n\n
We will use the sales.orders<\/code> and sales.order_items<\/code> from the sample database<\/a> for demonstration.<\/p>\n\n\n\n
\"Sample<\/figure>\n\n\n\n
This example uses the MONTH()<\/code> function to extract the month data from the values in the shipped_date<\/code> column. It returns the gross sales by month in 2018 using the SUM()<\/a><\/code> function and GROUP BY<\/a><\/code> clause:<\/p>\n\n\n
SELECT<\/span> MONTH<\/span>(shipped_date) [month<\/span>], \n    SUM<\/span>(list_price * quantity) gross_sales\nFROM<\/span> sales.orders o\n    INNER<\/span> JOIN<\/span> sales.order_items i ON<\/span> i.order_id = o.order_id\nWHERE<\/span> shipped_date IS<\/span> NOT<\/span> NULL<\/span>\n    AND<\/span> YEAR<\/span>(shipped_date) = 2017<\/span>\nGROUP<\/span> BY<\/span> MONTH<\/span>(shipped_date)\nORDER<\/span> BY<\/span> [month<\/span>];\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The following picture shows the output:<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
In this tutorial, you have learned how to extract the month from a specified date by using the SQL Server MONTH()<\/code> function.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t
The MONTH()<\/code> function takes an argument which can be a literal date value or an expression that can resolve to a TIME<\/a><\/code>, DATE<\/a><\/code>, SMALLDATETIME<\/code>, DATETIME<\/code>, DATETIME2<\/a><\/code>, or DATETIMEOFFSET<\/code> value.<\/p>\n\n\n\n