"John Goss" <[EMAIL PROTECTED]> writes:
> My problem is that when trying to SELECT a timestamp using "AT TIME ZONE
> 'Europe/London", it's subtracting an hour instead of adding it from a column
> storing UTC dates.
I think you've got a misunderstanding about the behavior of AT TIME ZONE.
It's real
I've been trawling the net trying to find an answer to this, so sorry if this is a common problem - I have tried looking before posting!
My problem is that when trying to SELECT a timestamp using "AT TIME ZONE 'Europe/London", it's subtracting an hour instead of adding it from a column storing UT