@postgrescafe : Avoid using TIMESTAMP (WITHOUT TIME ZONE) in Postgres Use TIMESTAMPTZ when storing a specific point in time. The naive TIMESTAMP lacks time zone context, making it unsuitable for time arithmetic. It also offers no performance or storage advantage over TIMESTAMPTZ. • TwiCopy

PostgresCafe

@postgrescafe

+ Follow

PostgreSQL Tips and Tricks

ID: 1044499465774788608

calendar_today25-09-2018 08:10:53

13 Tweet

12 Followers

25 Following

PostgresCafe

@postgrescafe

4 months ago

Avoid using TIMESTAMP (WITHOUT TIME ZONE) in Postgres Use TIMESTAMPTZ when storing a specific point in time. The naive TIMESTAMP lacks time zone context, making it unsuitable for time arithmetic. It also offers no performance or storage advantage over TIMESTAMPTZ.

thumb_up_off_alt1

chat_bubble_outline0

repeat0

shareShare