diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-02-16 03:39:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-02-16 03:39:46 +0000 |
| commit | 4ebb0cf9c30c1e477d5e2dfcc1f2c016c3f8bbcf (patch) | |
| tree | fd6ce21ac074478e57b9f55ff378a4ae1a04d14f /src/interfaces | |
| parent | c7b08050d9a2b68b27045b36ff4c9a3db85a55e4 (diff) | |
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
Diffstat (limited to 'src/interfaces')
| -rw-r--r-- | src/interfaces/ecpg/pgtypeslib/dt.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/interfaces/ecpg/pgtypeslib/dt.h b/src/interfaces/ecpg/pgtypeslib/dt.h index 95793aabc30..d0bfc00bbdd 100644 --- a/src/interfaces/ecpg/pgtypeslib/dt.h +++ b/src/interfaces/ecpg/pgtypeslib/dt.h @@ -1,4 +1,4 @@ -/* $PostgreSQL: pgsql/src/interfaces/ecpg/pgtypeslib/dt.h,v 1.34 2006/03/11 04:38:39 momjian Exp $ */ +/* $PostgreSQL: pgsql/src/interfaces/ecpg/pgtypeslib/dt.h,v 1.35 2007/02/16 03:39:45 momjian Exp $ */ #ifndef DT_H #define DT_H @@ -157,6 +157,7 @@ typedef double fsec_t; #define DTK_DOY 33 #define DTK_TZ_HOUR 34 #define DTK_TZ_MINUTE 35 +#define DTK_ISOYEAR 36 /* |