Re: [SQL] At time zone madness!

2006-04-20 Thread Tom Lane
"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

[SQL] At time zone madness!

2006-04-20 Thread John Goss
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