Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. YEARWEEK(date), YEARWEEK(date,mode) returns year and week for a date
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>