How to extract the month of year from a given date using the MONTH() function?

MONTH(date) is a MySQL built-in function that returns the month of year from a given date. For example:

SELECT MONTH('2023-02-03'), MONTH(NOW()), NOW();
  -- +---------------------+--------------+---------------------+
  -- | MONTH('2023-02-03') | MONTH(NOW()) | NOW()               |
  -- +---------------------+--------------+---------------------+
  -- |                   2 |           11 | 2023-11-15 08:19:34 |
  -- +---------------------+--------------+---------------------+

Reference information of the MONTH() function:

MONTH(date): int
  Returns the month for date, in the range 1 to 12 for January to
  December, or 0 for dates such as '0000-00-00' or '2008-00-00' that
  have a zero month part.

Arguments, return value and availability:
  date: Required. The date to extract the month of year from.
  int: Return value. The month of year.
  Available since MySQL 4.

Related MySQL functions:

• DAYOFMONTH() - Day of Month
• YEAR() - Year of Date
• QUARTER() - Quarter of Year

⇒ MONTHNAME() - Name of Month

⇐ MINUTE() - Minutes of Time

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References