根据当前时间获取最近5年时间:(yyyy)
SELECT to_char(SYSDATE,'YYYY') - LEVEL + 1 as "xAxisValue"
FROM dualCONNECT BY LEVEL <= 5
ORDER BY to_char(SYSDATE,'YYYY') - LEVEL + 1 ASC
根据当前时间获取最近6个月时间(yyyy-mm):
SELECT
TO_CHAR(add_months(to_date(to_char(trunc(sysdate, 'mm')+1, 'yyyy-mm'), 'yyyy-mm'), -(ROWNUM - 1)), 'yyyy-mm') as "xAxisValue"
FROM dual
CONNECT BY ROWNUM <= 6
ORDER BY TO_CHAR(add_months(to_date(to_char(trunc(sysdate, 'mm')+1, 'yyyy-mm'), 'yyyy-mm'), -(ROWNUM - 1)), 'yyyy-mm') ASC
根据当前时间获取最近30天时间:<