YEARWEEK(date), YEARWEEK(date,mode) returns year and week for a date. : YEARWEEK « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. YEARWEEK

The mode could be 0 ,1 ,2 ,3 ,4 ,5 ,6 ,7.

mysql>
mysql> SELECT YEARWEEK('1987-01-01');
+------------------------+
| YEARWEEK('1987-01-01') |
+------------------------+
|                 198652 |
+------------------------+
1 row in set (0.00 sec)

mysql>








14.59.YEARWEEK
14.59.1.YEARWEEK(date), YEARWEEK(date,mode) returns year and week for a date.
14.59.2.SELECT YEARWEEK('2000-01-01');
14.59.3.SELECT MID(YEARWEEK('2000-01-01'),5,2);