CREATE DEFINER=mysqladmin
@%
FUNCTION convertWeekToDate
(reportYear INT,reportWeek INT) RETURNS varchar(50) CHARSET utf8
BEGIN
DECLARE str_date VARCHAR(50) DEFAULT ”;
SET @dateYear = reportYear;
SET @dateWeek = reportWeek;
SET str_date = CONCAT(SUBSTRING_INDEX(str_to_date(concat(@dateYear, @dateWeek,’SUNDAY’), ‘%X%V%W’),’-‘,-2),”~”,SUBSTRING_INDEX(str_to_date(concat(@dateYear, @dateWeek,’SATURDAY’), ‘%X%V%W’),’-‘,-2));
RETURN str_date;
END
Original: https://www.cnblogs.com/lboke/p/15896902.html
Author: 在bug中写bug
Title: 周转换日期区间,SQL函数
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/594285/
转载文章受原作者版权保护。转载请注明原作者出处!