Re: [GENERAL] ISO week dates - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: [GENERAL] ISO week dates
Date
Msg-id 200610161901.35955.peter_e@gmx.net
Whole thread Raw
In response to Re: [GENERAL] ISO week dates  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-patches
Guillaume Lelarge wrote:
> Guillaume Lelarge a ecrit le 12/10/2006 20:20:
> > Peter Eisentraut a écrit :
> >> We should also support a format for ISO day-of-the-year, which
> >> might be 'IDDD'.
> >
> > I will work tomorrow on this one.
>
> Don't we already have it ? It seems ISO day-of-the-year is between
> 001 and 366 in leap years. Isn't this the definition for DDD format ?
> if Im' right, I just need to add the IDDD pattern ?

The ISO 8601 day-of-the-year is aligned with the week-of-the-year.  It
should be the case that day one of week one is also day one of the
year.

(As a particular example, day one of 2006 is January 2, 2006.)

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-patches by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: [GENERAL] ISO week dates
Next
From: Michael Paesold
Date:
Subject: Re: Constraint trigger doc patch