mysql 获取最近6个月的日期的 sql 实例
SELECT@lastDay := last_day( date_add(@lastDay,interval 1 month ) ) lastDaysfrom(SELECT @lastDay := date_add(curdate(),interval -6 month) from application limit 6) a;SELEC...
·
SELECT
@lastDay := last_day( date_add(@lastDay,interval 1 month ) ) lastDays
from
(SELECT @lastDay := date_add(curdate(),interval -6 month) from application limit 6) a;
SELECT
date_format(@lastDay := last_day( date_add(@lastDay,interval 1 month ) ) ,'%Y-%m' ) lastDays
from
(SELECT @lastDay := date_add(curdate(),interval -6 month) from application limit 6) a;
输出:
更多推荐
已为社区贡献25条内容
所有评论(0)