"Kevin Grittner" wrote:
> The withouttimezone column sees the literal in your local time and
s/withouttimezone/withtimezone/
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
"William Crawford" wrote:
> set time zone 'US/Eastern';
> select
> timestamp '2009-01-01',
> timestamp '2009-01-01' at time zone 'US/Pacific'
>as withouttimezone,
> timestamp with time zone '2009-01-01' at time zone 'US/Pacific'
>
The following bug has been logged online:
Bug reference: 4963
Logged by: William Crawford
Email address: will...@ezyield.com
PostgreSQL version: 8.3.7
Operating system: Gentoo
Description:Selecting timestamp without timezone at timezone gives
wrong output
Details:
s
