[ORACLE] FROM TO 에 안에 존재하는 날짜 조회

WITH T1 AS
(
  SELECT TO_DATE('202401010910', 'YYYY-MM-DD HH24:MI') START_DT
       , TO_DATE('202401010914',   'YYYY-MM-DD HH24:MI') END_DT
    FROM DUAL
  )
  SELECT TO_CHAR(START_DT + (LEVEL - 1) / 24 / 60, 'YYYYMMDDHH24MI')  AS GET_DAYS
    FROM T1
CONNECT BY LEVEL <= ((END_DT - START_DT) * 24 * 60 + 1)

분단위 : 1/24/60
시간단위 : 1/24

202401010910
202401010911
202401010912
202401010913
202401010914