How to extract the quarter of year from a given date using the QUARTER() function?

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

SELECT QUARTER('2023-02-03'), QUARTER(NOW()), NOW();
  -- +-----------------------+----------------+---------------------+
  -- | QUARTER('2023-02-03') | QUARTER(NOW()) | NOW()               |
  -- +-----------------------+----------------+---------------------+
  -- |                     1 |              4 | 2023-11-15 09:51:50 |
  -- +-----------------------+----------------+---------------------+

Reference information of the QUARTER() function:

QUARTER(date): int
  Returns the quarter of the year for date, in the range 1 to 4.

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

Related MySQL functions:

• MONTH() - Month of Year

⇒ SECOND() - Seconds of Time

⇐ PERIOD_DIFF() - Difference of Year-Month Periods

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References