Re: BUG #1648: ISO Year ignores time zone?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nicholas Vinen" <hb(at)x256(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1648: ISO Year ignores time zone?
Date: 2005-05-05 14:55:43
Message-ID: 23497.1115304943@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Nicholas Vinen" <hb(at)x256(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-05-05 15:53:27 Re: BUG #1545: LIBPQ Windows Version not calling WSACleanup for
Previous Message Tom Lane 2005-05-05 14:39:45 Re: BUG #1647: shows version 7.1, doesnt create tablespaces etc.