Sample Header Ad - 728x90

Generate series of time ranges

2 votes
1 answer
606 views
I know we can use Postgres' generate_series() function to produce a set of timestamps. Can we do the same to produce a set of time ranges directly without having to manually convert generated timestamps into time ranges like so?
SELECT tstzrange(
   time_stamp,
   time_stamp + '1 days'
   '[)'
) AS time_range
FROM generate_series(
   '2022-01-01'::TIMESTAMPTZ,
   '2022-02-01'::TIMESTAMPTZ,
   '1 days'
) tmp(time_stamp);
Asked by eliangius (155 rep)
Jun 5, 2022, 10:14 PM
Last activity: Nov 20, 2024, 09:53 AM