| From: | tgl(at)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Fix handling of CC (century) format spec in to_date/to_char. |
| Date: | 2007-01-12 23:35:04 |
| Message-ID: | 20070112233504.31B3D9FB433@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Log Message:
-----------
Fix handling of CC (century) format spec in to_date/to_char. According to
standard convention the 21st century runs from 2001-2100, not 2000-2099,
so make it work like that. Per bug #2885 from Akio Iwaasa.
Backpatch to 8.2, but no further, since this is really a definitional
change; users of older branches are probably more interested in stability.
Tags:
----
REL8_2_STABLE
Modified Files:
--------------
pgsql/doc/src/sgml:
func.sgml (r1.347 -> r1.347.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.347&r2=1.347.2.1)
pgsql/src/backend/utils/adt:
formatting.c (r1.116 -> r1.116.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/formatting.c.diff?r1=1.116&r2=1.116.2.1)
pgsql/src/test/regress/expected:
timestamp.out (r1.31 -> r1.31.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamp.out.diff?r1=1.31&r2=1.31.2.1)
timestamptz.out (r1.21 -> r1.21.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamptz.out.diff?r1=1.21&r2=1.21.2.1)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2007-01-13 03:17:34 | pgsql: Back port patch. |
| Previous Message | Tom Lane | 2007-01-12 23:34:55 | pgsql: Fix handling of CC (century) format spec in to_date/to_char. |