Skip to content

Instantly share code, notes, and snippets.

@hendrysuwanda

hendrysuwanda/oracle_generate_date_between_2_date_ranges.sql

Last active September 15, 2017 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hendrysuwanda/d4bc30efb9e3231a3c2c66b3b703b643 to your computer and use it in GitHub Desktop.
Save hendrysuwanda/d4bc30efb9e3231a3c2c66b3b703b643 to your computer and use it in GitHub Desktop.
Download ZIP
how to generating dates between two date ranges (ex: from 20-Mar-2015 until 20-Apr-2015)
Raw
oracle_generate_date_between_2_date_ranges.sql
select to_date('20032015','ddMMyyyy') + rownum -1 price_date
from all_objects
where rownum <= to_date('20042015','ddMMyyyy')-to_date('20032015','ddMMyyyy')+1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment