先看下效果
输入参数20181010 20181101
结果图
实现步骤
上代码
CREATE DEFINER=`root`@`localhost` PROCEDURE `date_dowhile`(i_begindate VARCHAR(20), i_enddate VARCHAR(20))
BEGIN
#Routine body goes here...
declare v_firstday date;
declare v_lastday date;
select date_format(i_begindate,'%Y-%m-%d'),date_format(i_enddate,'%Y-%m-%d') into v_firstday,v_lastday;
D