Getting the first and the last day of current week in MySQL

29/04/2015 - MYSQL

Command below are used to get the first and the last day of current week.


First day


mysql> SELECT DATE_FORMAT(subdate(now(), INTERVAL weekday(now()) DAY), '%d/%m/%Y') as FirstDay;
+------------+
| FirstDay   |
+------------+
| 27/04/2015 |
+------------+
1 row in set (0.00 sec)

Last day


mysql> SELECT DATE_FORMAT(adddate(now(), INTERVAL 6-weekday(now()) DAY), '%d/%m/%Y') as LastDay;
+------------+
| LastDay    |
+------------+
| 03/05/2015 |
+------------+
1 row in set (0.00 sec)