Oracle get date formatted as string between two dates

Question

I am trying to work with 2 formatted dates, if I have TO_DATE('20160101' YYMMDD) and TO_DATE('20160104', YYMMDD) I would like to receive this output:

20160101
20160102
20160103
20160104

Is there a fast way to achieve this without using PL/SQL?

Thanks to all!

Answer 1

The format mask in to_date() must be enclosed within single quotes too.

To produce the output in string format you need to apply to_char() with the same format mask.

select to_char(to_date('20160101', 'YYYYMMDD') + level - 1, 'YYYYMMDD') as dt
from   dual
connect by level <= 1 + to_date('20160104', 'YYYYMMDD') - to_date('20160101', 'YYYYMMDD')
;


DT     
--------
20160101
20160102
20160103
20160104