Compute Date in MySQL Using Year, Week Number, and Day of the Week

We can compute the date as follows −

mysql> SET @year=2017, @week=15, @day=4;
Query OK, 0 rows affected (0.00 sec)

The above query will pass the value’2017’ ,’15’, ‘4’ in ‘year’, ’week’ and ‘day’ variables respectively. Then after applying the formula in the query below, we can get the date.

mysql> SELECT Str_To_Date( Concat(@year,'-',@week,'-',If(@day=7,0,@day) ), '%Y-%U-%w' ) AS Date;
+--------------+
| Date         |
+--------------+
| 2017-04-13   |
+--------------+
1 row in set (0.00 sec)