Sample Header Ad - 728x90

generate a series of dates in progress-db

1 vote
1 answer
128 views
I am looking for a way in progress-db to generate a series of dates in the same way I would in PostgreSQL. select date::date from generate_series( '2021-01-07'::date ,'2021-01-12'::date ,'1 day'::interval ) date; Returns the following dataset in rows: > 1/7/2021 , 1/8/2021, 1/9/2021, 1/10/2021, 1/11/2021, 1/12/2021 I looked in the documentation, but I am unable to find any generate_series keywords or anything like it. Is this something that can be done in this RDBMS? If this is not possible, please let me know.
Asked by Daniel L. VanDenBosch (408 rep)
Feb 2, 2021, 02:21 PM
Last activity: Feb 6, 2021, 09:09 PM