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

In MySQL, how we can compute date by providing the year, week number and day of the week?\\nday 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)
Updated on: 2020-01-28T10:04:30+05:30

134 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements