Author updates blog with clearer summary
2 Sep 27 2:26 AM · 2d ago · 3 comments · 1 source · development 2 of 4
The blog post author modifies the article to add a summary at the top, explicitly stating that timestamptz AT TIME ZONE 'UTC' converts to timestamp without timezone.
“timestamptz AT TIME ZONE 'UTC' gives us a timestamp without time zone i.e. timestamp, not a timestamptz. It converts the data type to timestamp without time zone.”
tanin47tanin47 Blog post author
The whole story articlespostscomments the bright band is this development · numbered dots are the others · click one to jump
What people said 3 voices · verbatim
-
> timestamptz AT TIME ZONE 'UTC' gives you the representation of a moment of time in the UTC time zone I modified the blog to be clearer with a summary at the top. To clarify: `timestamptz AT TIME ZONE 'UTC'` gives us a timestamp without time zone i.e. `timestamp`, not a `timestamptz`. It converts the data type to `timestamp without time zone`.
-
You loose information if you only save utc. If you save the location of the event separately that is fine, but also forces you to do the math manually. I would say it always depends on what data you are actually saving.
-
The TLDR is actually: `AT TIME ZONE 'UTC'` converts the data type from `timestamp with timezone` to `timestamp without timezone`. I've modified the blog post to add the summary at the top!
All 4 developments of Postgres AT TIME ZONE 'UTC' converts data type unexpectedly →
RedditHacker NewsMastodonNewswires