Casting to timestamps is done through timestamp without timezone.
Converting timezones, when we only specify a string (the destination), considers that we're starting from UTC, and doesn't leave it to interpretation. If you want to specify the starting timezone, pass a hash.
In this PR 2 things happened for postgres:
timestamp without timezone
.