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 1200+ tech skills courses.