In MySQL, how can we calculate a date by providing the year, week number and day of the week?

We can calculate 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" in the "year", "week" and "day" variables respectively ", "15", "4". 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)

The above is the detailed content of In MySQL, how can we calculate a date by providing the year, week number and day of the week?. For more information, please follow other related articles on the PHP Chinese website!