Comment by asah

In nearly all cases, I recommend people use TIMESTAMPTZ with UTC timezone (i.e. convert on the way in). If possible, operate your apps with UTC until it hits a user's eyes, i.e. internally define your "day" to start in ~Greenwich UK.

This saves a __lot__ of headaches, of which timestamp vs timestamptz is the tip of the iceberg.