{"id":6214,"date":"2017-07-09T06:46:51","date_gmt":"2017-07-09T13:46:51","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=6214"},"modified":"2023-10-15T21:15:01","modified_gmt":"2023-10-16T04:15:01","slug":"mysql-month-function","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-month-function\/","title":{"rendered":"MySQL MONTH() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL MONTH()<\/code> function to get the month of a given date.<\/p>\n\n\n\n

Introduction to MySQL MONTH() function<\/h2>\n\n\n\n

The MONTH<\/code> function returns an integer<\/a> that represents the month of a specified date. The following illustrates the syntax of the MONTH<\/code> function:<\/p>\n\n\n

MONTH(date);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The MONTH()<\/code> function returns NULL<\/code> if the date is NULL<\/code>. Also, it returns zero, if the date is zero (0000-00-00<\/code>).<\/p>\n\n\n\n
MySQL MONTH() function examples<\/h2>\n\n\n\n
Let’s take some examples of using the MONTH() function<\/p>\n\n\n\n
1) Simple Month() function examples<\/h3>\n\n\n\n
The following example uses the MONTH()<\/code> function to get the month of 2010-01-01<\/code>:<\/p>\n\n\n
SELECT MONTH('2010-01-01'<\/span>);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+---------------------+<\/span>\n| MONTH('2010-01-01') |\n+---------------------+<\/span>\n|                   1 |\n+---------------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To get the current month, you use the MONTH()<\/code> function with the NOW()<\/code> function as shown in the following statement:<\/p>\n\n\n
SELECT MONTH(NOW()) CURRENT_MONTH;<\/code><\/span><\/pre>\n\n\n
Output:<\/p>\n\n\n
+---------------+<\/span>\n| CURRENT_MONTH |\n+---------------+<\/span>\n|            10 |\n+---------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
How it works.<\/p>\n\n\n\n
The MONTH<\/code> function accepts one argument which is a DATE<\/code><\/a> or DATETIME<\/a><\/code> value. It returns an integer that ranges from 1 to 12, which represents January to December.<\/p>\n\n\n\n