=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <clodoaldo_pinto(at)yahoo(dot)com(dot)br> writes:
> It does not work for a timestamp with time zone column:
> # select to_char(timestamp with time zone '2001-02-16 20:38:40-05' at
> time zone 'BRT', 'HH24:MI DD/MM/YYYY TZ');
> to_char
> -------------------
> 22:38 16/02/2001
> Is it the expected behavior?
Yes. AT TIME ZONE converts a timestamp without time zone to a timestamp
with time zone, or vice versa.
regards, tom lane