sql代码如下:
SELECT to_char (SYSDATE- LEVEL + 1, 'yyyy-mm-dd') today FROM DUAL connect BY LEVEL <= 7
查询结果如下: