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

MySQLMySQLi Database

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)
raja
Published on 19-Feb-2018 11:05:15
Advertisements