PostgreSQL Date & Time: The Working Engineer's Cheat Sheet

Dates are where "it works on my machine" queries go to die: DST shifts, month-end overflow, inclusive BETWEEN on timestamps, ISO-year mismatches. This is a fast, opinionated refresher for people who a