Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]
PostgreSQL: mapping timestamps (date_bin)
How to map timestamps to time bins: In PostgreSQL 14, a new function date_bin has been added which maps date & time to time buckets.
Time in PostgreSQL: Outer joins
UPDATED Aug 2023: How to use “generate_series” in an outer join: Use PostgreSQL to aggregate data on an hourly basis.