Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1648: ISO Year ignores time zone? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1648: ISO Year ignores time zone?
Date
Msg-id 23497.1115304943@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1648: ISO Year ignores time zone?  ("Nicholas Vinen" <hb@pg.x256.org>)
List pgsql-bugs
Tree view 
"Nicholas Vinen" <hb@x256.com> writes:
> rt3=# SELECT to_char(timestamp with time zone '2003-12-31 14:44:44-08', 'Mon
> IYYY');
>  to_char
> ----------
>  Dec 2004
> (1 row)

I believe that's correct.  2003-12-31 falls into the first week of ISO 2004.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1647: shows version 7.1, doesnt create tablespaces etc.
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1545: LIBPQ Windows Version not calling WSACleanup for