How to extract the year from a given date using the YEAR() function?

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

SELECT YEAR('2007-08-09'), YEAR(NOW()), NOW();
  -- +--------------------+-------------+---------------------+
  -- | YEAR('2007-08-09') | YEAR(NOW()) | NOW()               |
  -- +--------------------+-------------+---------------------+
  -- |               2007 |        2023 | 2023-11-15 08:25:19 |
  -- +--------------------+-------------+---------------------+

Reference information of the YEAR() function:

YEAR(date): int
  Returns the year for date, in the range 1000 to 9999, or 0 for
  the “zero” date.

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

Related MySQL functions:

• DAYOFMONTH() - Day of Month
• MONTH() - Month of Year

⇒ YEARWEEK() - Year Week Combination

⇐ WEEKOFYEAR() - Calendar Week of Year

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References