MySQL自建函数之得到两个日期间连续的日期

雪翊寒

于 2015-10-10 11:31:31 发布

阅读量781

点赞数

分类专栏：数据库文章标签： mysql diff

本文链接：https://blog.youkuaiyun.com/yixian918/article/details/49021753

版权

数据库专栏收录该内容

43 篇文章

订阅专栏

DELIMITER $$
CREATE DEFINER=`root`@`localhost` FUNCTION `get`(endDate varchar(250),
startDate varchar(250)) RETURNS varchar(400) CHARSET latin1
BEGIN
declare str varchar(400) default startDate;
declare diff int default 0;
declare num int default 1;
set diff=DATEDIFF(endDate,startDate)+1;
while num != diff do
set str=CONCAT(str,";",DATE_ADD(startDate,INTERVAL num DAY));
set num = num + 1;
end while;
RETURN str;
END