Date/Time and Time Zones
Learn how the date, time, and time zones work in PostgreSQL.
Handling dates, time, and time zones is a very complex matter, and on this topic, we can read Erik Naggum’s piece, “The Long, Painful History of Time.”
The timestamp data type
The first question we need to answer here is about using timestamps with or without time zones from our applications. The answer is simple: always use timestamps with time zones.
A common myth is that storing time zones will certainly add to our storage and memory footprint. It’s actually not the case:
Get hands-on with 1400+ tech skills courses.