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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c7b0805) | patch
Add two new format fields for use with to_char(), to_date() and
2007年2月16日 03:39:46 +0000 (03:39 +0000)
2007年2月16日 03:39:46 +0000 (03:39 +0000)
commit 4ebb0cf9c30c1e477d5e2dfcc1f2c016c3f8bbcf
Add two new format fields for use with to_char(), to_date() and
to_timestamp():
- ID for day-of-week
- IDDD for day-of-year

This makes it possible to convert ISO week dates to and from text
fully represented in either week ('IYYY-IW-ID') or day-of-year
('IYYY-IDDD') format.

I have also added an 'isoyear' field for use with extract / date_part.

Brendan Jurd
12 files changed:
doc/src/sgml/func.sgml diff | blob | blame | history
src/backend/utils/adt/date.c diff | blob | blame | history
src/backend/utils/adt/datetime.c diff | blob | blame | history
src/backend/utils/adt/formatting.c diff | blob | blame | history
src/backend/utils/adt/timestamp.c diff | blob | blame | history
src/include/utils/datetime.h diff | blob | blame | history
src/include/utils/timestamp.h diff | blob | blame | history
src/interfaces/ecpg/pgtypeslib/dt.h diff | blob | blame | history
src/test/regress/expected/timestamp.out diff | blob | blame | history
src/test/regress/expected/timestamptz.out diff | blob | blame | history
src/test/regress/sql/timestamp.sql diff | blob | blame | history
src/test/regress/sql/timestamptz.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /