Learning Oracle SQL and PL/SQL
Tuesday, May 10, 2016
How to find dates between two given dates
By using below query, it is possible to generate dates between to given dates.
SELECT start_date - 1 + rownum as p_date
FROM all_objects
WHERE start_date - 1 + rownum <= end_date
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment