Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT MID(YEARWEEK(2000-01-01),5,2)
mysql>
mysql> SELECT MID(YEARWEEK('2000-01-01'),5,2);
+---------------------------------+
| MID(YEARWEEK('2000-01-01'),5,2) |
+---------------------------------+
| 52                              |
+---------------------------------+
1 row in set (0.00 sec)
mysql>