And why you may need to repeat AT TIME ZONE 'UTC' twice.
SUMMARY
* AT TIME ZONE 'UTC' converts the data type from timestamptz to timestamp (example).
* Now you are inadvertently using the timestamp without time zone (aka timestamp) data type, which is markedly discouraged.
* There are tons of footguns with timestamp.
* For example, the equality of timestamp and timestamptz will always be false..... unless your Postgres' default timezone is UTC. Read more.
* Adding a month wit
You don't know what I think it does. Fuck clickbait.
save