+ 1
How to find start date of particular yearweek in mysql?
I have yearweek of buch of records. I need to find star date and end date of that particular yearweek in mysql. Note here any date is not dependent upon curdate(). Any possible?
1 ответ
+ 2
I would try something like
STR_TO_DATE(yearweek_data, '%X%V')
But this may not be enough as the docs says also the name of the day may be required to uniquely identify the date. Check details here
https://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_str-to-date