Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk> writes:
> Thanks Tom. Timestamps are going into the database which are implicitly
> UTC, and I was looking for a way to convert them when displayed to the
> local timezone (the client gets this from a configuration file and puts
> it in the query) and also to present the timezone name.
Consider setting timezone to what the client asks for.
> So I think that what you're saying is that the result from to_char()
> will always be UTC, possibly corrected for daylight saving (i.e. GMT or
> BST respectively).
No, the result is computed on the assumption that we're in the zone
specified by the timezone setting. This might be hard to wrap your head
around if you only test in GMT or GMT0BST zones --- try something where
the offset is never zero to get a clearer picture of what's going on.
regards, tom lane