SELECT TO_CHAR(ADD_MONTHS(ADD_MONTHS(sysdate, -24), ROWNUM - 1), 'YYYYMM') UNIT_DATE FROM DUAL CONNECT BY ROWNUM <= months_between(sysdate, ADD_MONTHS(sysdate, -24))从Oracle替换成postgre

SELECT to_char(date_trunc('MONTH',CURRENT_DATE - interval '2 year') + interval '1 month' * generate_series(0, date_part('year', age(CURRENT_DATE - interval '2 year')) * 12 + date_part('month', age(CURRENT_DATE - interval '2 year')) - 1), 'YYYYMM') AS UNIT_DATE FROM generate_series(0, date_part('year', age(CURRENT_DATE - interval '2 year')) * 12 + date_part('month', age(CURRENT_DATE - interval '2 year')) - 1) s;

相关问题

SELECT TO_CHAR(ADD_MONTHS(ADD_MONTHS(sysdate, -24), ROWNUM - 1), 'YYYYMM') UNIT_DATE FROM DUAL CONNECT BY ROWNUM <= months_between(sysdate, ADD_MONTHS(sysdate, -24)) 替换成postgre

SELECT to_char(date_trunc('month', (CURRENT_DATE - interval '2 year')::timestamp) + (generate_series(0, date_part('year', age(CURRENT_DATE, (CURRENT_DATE - interval '2 year'))::interval) * 12 + date_part('month', age(CURRENT_DATE, (CURRENT_DATE - interval '2 year'))::interval)) * interval '1 month'), 'YYYYMM') AS UNIT_DATE FROM generate_series(0, date_part('year', age(CURRENT_DATE, (CURRENT_DATE - interval '2 year'))::interval) * 12 + date_part('month', age(CURRENT_DATE, (CURRENT_DATE - interval '2 year'))::interval)) AS t;

SELECT REMARK FROM H_LOG_PRODUCTEVENT WHERE TRACK_OUT_TIME BETWEEN TO_DATE(TO_CHAR(SYSDATE-1,'YYYY-MM-DD')||' 16:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(TO_CHAR(SYSDATE-1,'YYYY-MM-DD')||' 17:00:00', 'YYYY-MM-DD HH24:MI:SS')-1/86400 and AREA ='02201'; 查询的时间换成今天九点 和十点

你的问题是如何将查询时间从昨天下午4点到5点改为今天上午9点到10点？

你可以将查询语句中的时间范围部分修改为以下内容：

BETWEEN TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD')||' 09:00:00', 'YYYY-MM-DD HH24:MI:SS')
        AND TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD')||' 10:00:00', 'YYYY-MM-DD HH24:MI:SS')-1/86400

这样就可以查询今天上午9点到10点之间的数据了。