YEAR(date) returns the year for date, in the range 1000 to 9999, or 0 for the 'zero' date. : YEAR « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. YEAR
mysql>
mysql> SELECT YEAR('98-02-03');
+------------------+
| YEAR('98-02-03') |
+------------------+
|             1998 |
+------------------+
1 row in set (0.00 sec)

mysql>








14.58.YEAR
14.58.1.YEAR(date) returns the year for date, in the range 1000 to 9999, or 0 for the 'zero' date.
14.58.2.YEAR(date) returns the 4-digit numeric year of a given date:
14.58.3.select YEAR('1973-07-20');