mysql中将年和周次转换成日期的函数

mysql中将年和周次转换成日期

假设周日为为第一天

 

获取某年某周的第一天

CREATE FUNCTION getFirstDayOfWeek(reportWeek INT, reportYear INT)
  RETURNS date
BEGIN
  declare begin_date date ;
SET begin_date = str_to_date(concat(reportYear, reportWeek, " ", 'SUNDAY'), '%X%V %W');
RETURN begin_date;
END

获取某年某周的最后一天

CREATE FUNCTION  getLastDayOfWeek(reportWeek INT, reportYear INT)
  RETURNS date
BEGIN
  declare end_date date ;
SET end_date = str_to_date(concat(reportYear, reportWeek, " ", 'SATURDAY'), '%X%V %W');
RETURN end_date;
END