Re: [BUGS] BUG #1058: unexpected output when using timezone() and to_char()

2004-01-21 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > however, > select to_char(timezone('PST',CURRENT_TIMESTAMP),' Day Mon DD > 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.

[BUGS] BUG #1058: unexpected output when using timezone() and to_char()

2004-01-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1058 Logged by: Blake Crosby Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: FreeBSD 5.1-RELEASE-p11 Description:unexpected output when using timezone() and to_char() Details: