Thread: One more example of generating time series

One more example of generating time series

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/functions-srf.html
Description:

I find this kind of query very useful:

If you don't know the end date, but you know how many time steps to add, you
can use a query like this
select now()+ '1 day'::interval *generate_series(1,5);