Просмотр исходного текста страницы MySQL Tutorial/Date Time Functions/YEAR

== select YEAR("1973-07-20");==



   
  <!-- start source code -->
   
    <source lang="sql">
mysql>
mysql>
mysql> select YEAR("1989-07-20");
+--------------------+
| YEAR("1989-07-20") |
+--------------------+
|               1989 |
+--------------------+
1 row in set (0.00 sec)
mysql></source>
    
   

== YEAR(date) returns the 4-digit numeric year of a given date:==



   
  <!-- start source code -->
   
    <source lang="sql">
mysql>
mysql> SELECT YEAR("01/12/25 11:00:00");
+---------------------------+
| YEAR("01/12/25 11:00:00") |
+---------------------------+
|                      2001 |
+---------------------------+
1 row in set (0.00 sec)
mysql></source>
    
   

== YEAR(date) returns the year for date, in the range 1000 to 9999, or 0 for the "zero" date.==



   
  <!-- start source code -->
   
    <source lang="sql">
mysql>
mysql> SELECT YEAR("98-02-03");
+------------------+
| YEAR("98-02-03") |
+------------------+
|             1998 |
+------------------+
1 row in set (0.00 sec)
mysql></source>