Re: [GENERAL] ISO week dates

2006-11-23 Thread Brendan Jurd
On 11/24/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: Brendan Jurd wrote: > On 11/23/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: >> Just verifying, but aren't both formats ISO? In that case maybe it'd be >> better to have a (per database) setting that specifies which one? > > The term "ISO" is

Re: [GENERAL] ISO week dates

2006-11-23 Thread Alban Hertroys
Brendan Jurd wrote: > On 11/23/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: >> Bruce Momjian wrote: >> > Peter Eisentraut wrote: >> >> Brendan Jurd wrote: >> >>> * add an ISO day format pattern to to_char() called 'ID', which >> >>> starts at Monday = 1, and >> >>> * add an ISO year field to ext

Re: [GENERAL] ISO week dates

2006-11-23 Thread Brendan Jurd
On 11/23/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: Bruce Momjian wrote: > Peter Eisentraut wrote: >> Brendan Jurd wrote: >>> * add an ISO day format pattern to to_char() called 'ID', which >>> starts at Monday = 1, and >>> * add an ISO year field to extract() called 'isoyear'? >> That seems

Re: [GENERAL] ISO week dates

2006-11-23 Thread Alban Hertroys
Bruce Momjian wrote: > Peter Eisentraut wrote: >> Brendan Jurd wrote: >>> * add an ISO day format pattern to to_char() called 'ID', which >>> starts at Monday = 1, and >>> * add an ISO year field to extract() called 'isoyear'? >> That seems reasonable. Do you volunteer? > > Added to TODO: > >

Re: [GENERAL] ISO week dates

2006-11-22 Thread Bruce Momjian
Peter Eisentraut wrote: > Brendan Jurd wrote: > > * add an ISO day format pattern to to_char() called 'ID', which > > starts at Monday = 1, and > > * add an ISO year field to extract() called 'isoyear'? > > That seems reasonable. Do you volunteer? Added to TODO: * Add ISO day of week

Re: [PATCHES] [GENERAL] ISO week dates

2006-10-12 Thread Guillaume Lelarge
Heikki Linnakangas a ecrit le 12/10/2006 12:43: Guillaume Lelarge wrote: I've tried to work on the first one, the ISO day field. My patch is attached and is against CVS HEAD. It only takes care of the code, nothing is done for documentation matter. It works with me : I haven't been following

Re: [PATCHES] [GENERAL] ISO week dates

2006-10-12 Thread Heikki Linnakangas
Guillaume Lelarge wrote: I've tried to work on the first one, the ISO day field. My patch is attached and is against CVS HEAD. It only takes care of the code, nothing is done for documentation matter. It works with me : I haven't been following this thread, but I just wanted to point out that

Re: [GENERAL] ISO week dates

2006-10-12 Thread Guillaume Lelarge
Peter Eisentraut a ecrit le 07/10/2006 09:01: Brendan Jurd wrote: * add an ISO day format pattern to to_char() called 'ID', which starts at Monday = 1, and * add an ISO year field to extract() called 'isoyear'? That seems reasonable. Do you volunteer? I've tried to work on the first one,

Re: [GENERAL] ISO week dates

2006-10-07 Thread Peter Eisentraut
Brendan Jurd wrote: > * add an ISO day format pattern to to_char() called 'ID', which > starts at Monday = 1, and > * add an ISO year field to extract() called 'isoyear'? That seems reasonable. Do you volunteer? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---

[GENERAL] ISO week dates

2006-10-01 Thread Brendan Jurd
Hey guys,I have a question regarding the ISO 8601 week date format.  Outputting dates in this format seems to be partially supported, and rather inconsistent.  The documentation for to_char() lists 'IYYY' (ISO year) and 'IW' (ISO week) as format patterns, but there is no "ISO day of week" format pa