mysql 周 获取日期_MySQL获取日期周、月、天，生成序号

MySQL时间格式化：  %Y-%m-%d %H:%i:%s.%f

SELECT DATE_FORMAT(‘2020-04-12 15:23:16.463‘,‘%Y-%m-%d %H:%i:%s.%f‘)

2020-04-12 15:23:16.463000

SELECT @cdate := date_add(@cdate, interval - 1 day) as date FROM(SELECT @cdate := date_add(date_sub(CURDATE(),interval 1 DAY), interval + 1 DAY) from resource_publish) t0 LIMIT 7

SELECT @cdate := date_add(@cdate, interval - 1 day) as date_str FROM(SELECT @cdate := date_add(CURDATE(), interval + 1 DAY) from resource_publish) t0 LIMIT 7

SELECT @cdate := date_add(@cdate, interval - 1 day) as date_str FROM(SELECT @cdate := date_add(‘20200402‘, interval + 1 DAY) from resource_publish) t0 LIMIT 7

SELECT @cdate := date_add(@cdate, interval - 1 MONTH) as date_str FROM(SELECT @cdate := date_add(CURDATE(), interval + 1 MONTH) from resource_publish) t0 LIMIT 12

-- 查询最近七个月每月一号

SELECT @cdate := date_add(@cdate, interval - 1 MONTH) as daytime FROM(SELECT @cdate := date_add(date_sub(CURDATE(),interval 1 MONTH), interval + 1 MONTH) from view_wl018_mx) t0 LIMIT 7;

-- 查询最近七个月每月月末

SELECT @lastDay := last_day( date_add(@lastDay,interval 1 month )) lastDays from (SELECT @lastDay := date_add(curdate(),interval -6 month) from view_wl018_mx 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 view_wl018_mx 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 -MONTH(curdate()) month) from vie