git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix handling of CC (century) format spec in to_date/to_char. According to

author Tom Lane <tgl@sss.pgh.pa.us>

2007年1月12日 23:34:55 +0000 (23:34 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

2007年1月12日 23:34:55 +0000 (23:34 +0000)

commit 9a54b76b39b89de2f0238a9e4d570972cf758fd8

tree ab5b2fa640ad316d8064caad9b497f68e5063846 tree

parent 113fbe1264a8b6d757afc54c6df29de80720c7bd commit | diff

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.

doc/src/sgml/func.sgml diff | blob | blame | history

src/backend/utils/adt/formatting.c diff | blob | blame | history

src/test/regress/expected/timestamp.out diff | blob | blame | history

src/test/regress/expected/timestamptz.out diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom