SELECT
TO_CHAR ( TRUNC ( to_Date ( '${startTime}', 'YYYY-MM-DD' ), 'DD' ) + ROWNUM - 1, 'YYYY-MM-DD' ) AS YWSCSJ
FROM
DUAL CONNECT BY ROWNUM < TRUNC ( to_Date ( '${endTime}', 'YYYY-MM-DD' ), 'DD' ) - TRUNC ( to_Date ( '${startTime}', 'YYYY-MM-DD' ), 'DD' ) + 1 ;
上诉SQL可查询出指定字符串时间之间的所有时间,${startTime}可传入参数值如“2019-02-01”,${endTime}可传入参数值如“2019-03-02”,查出结果如下:
YWSCSJ
2019-02-01
2019-02-02
2019-02-03
2019-02-04
2019-02-05
2019-02-06
2019-02-07
2019-02-