MySQL自建函數之得到兩個日期間連續的日期

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