|
Home > Archive > PostgreSQL Bugs > May 2005 > BUG #1648: ISO Year ignores time zone?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BUG #1648: ISO Year ignores time zone?
|
|
| Nicholas Vinen 2005-05-05, 9:24 am |
|
The following bug has been logged online:
Bug reference: 1648
Logged by: Nicholas Vinen
Email address: hb@pg.x256.org
PostgreSQL version: 8.0.1
Operating system: Gentoo Linux
Description: ISO Year ignores time zone?
Details:
rt3=# SELECT to_char(timestamp with time zone '2003-12-31 14:44:44-08', 'Mon
IYYY');
to_char
----------
Dec 2004
(1 row)
rt3=# SELECT to_char(timestamp with time zone '2003-12-31 14:44:44-08', 'Mon
YYYY');
to_char
----------
Dec 2003
(1 row)
Is that correct? It confused me... there doesn't seem to be a description in
the documentation which mentions IYYY what exactly an ISO year is...
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
| |
| Tom Lane 2005-05-05, 11:24 am |
| "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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
|
|
|