New answers tagged


In order to answer this, I did the following (all the code below is in the (new) fiddle here): CREATE TABLE test ( the_date TIMESTAMP NOT NULL ); Populate it - added records for a day with no gaps > 3 hours... INSERT INTO test VALUES ('2021-06-23 05:47:05'::TIMESTAMPTZ), -- NO gaps > 3 hours on this date! ('2021-06-23 07:47:05'::TIMESTAMPTZ), ('...

Top 50 recent answers are included