"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> however,
> select to_char(timezone('PST',CURRENT_TIMESTAMP),' Day Mon DD YYYY
> HH24:MI:SS TZ');
> returns:
> Wednesday Jan 21 2004 07:07:44
> Notice the Time zone field (specified by 'TZ' in the to_char) is missing
> from the output.
This isn't a bug. The timezone() function returns datatype timestamp
without time zone, so there is nothing that to_char could usefully
print.
regards, tom lane