Add two new format fields for use with to_char(), to_date() and
Bruce Momjian <bruce@momjian.us>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +55 −3 |
| src/backend/utils/adt/date.c | modified | +2 −1 |
| src/backend/utils/adt/datetime.c | modified | +2 −1 |
| src/backend/utils/adt/formatting.c | modified | +119 −52 |
| src/backend/utils/adt/timestamp.c | modified | +57 −13 |
| src/include/utils/datetime.h | modified | +2 −1 |
| src/include/utils/timestamp.h | modified | +5 −2 |
| src/interfaces/ecpg/pgtypeslib/dt.h | modified | +2 −1 |
| src/test/regress/expected/timestamp.out | modified | +247 −0 |
| src/test/regress/expected/timestamptz.out | modified | +236 −73 |
| src/test/regress/sql/timestamp.sql | modified | +25 −0 |
| src/test/regress/sql/timestamptz.sql | modified | +21 −4 |