oracle
条件限制为取2018年至2023中的每个年初,sql该怎么写
每年第一天?
SELECT TO_DATE('01-01-2018', 'DD-MM-YYYY') + (level - 1) * interval '1' year AS "YEAR"
FROM dual
CONNECT BY level <= 6;
SELECT TO_DATE('01-01-' || YEAR, 'DD-MM-YYYY') AS "YEAR_START"
FROM DUAL
WHERE YEAR BETWEEN 2018 AND 2023;