PostgreSQL generate_series

select generate_series(TO_DATE('01.01.2023','DD.MM.YYYY'),TO_DATE('31.01.2023','DD.MM.YYYY'),interval '1 day')::date 
from dual;