mysql - 我如何使用小于等于或之间的函数 FROM DUAL 表？

Question

我试图获取从上周到当前的日期，但似乎 或 >= 在这里不起作用。

WITH curr_cyc_dt AS (
    SELECT BETWEEN TO_DATE ('20181228', 'yyyymmdd') AND TO_DATE ('20190104', 'yyyymmdd') cyc_dt 
    FROM DUAL
)

Answer 1

set @myDate = CURDATE();
set @rowNumber = 0;

select date_sub(@myDate, interval @rowNumber day),
(@rowNumber := @rowNumber + 1) as rownum
  from information_schema.columns
LIMIT 7;