Re: [HACKERS] Week numbers and years

2003-06-29 Thread Bruno Wolff III
On Wed, Jun 25, 2003 at 14:05:10 +0200, Brage <[EMAIL PROTECTED]> wrote: > A minor feature request: > > PostgreSQL supports ISO-8601 week numbers with the syntax EXTRACT(WEEK FROM > timestamp) or TO_CHAR(timestamp,'IW'). There is, however, no easy way to > extract the year corresponding to the w

[HACKERS] Week numbers and years

2003-06-28 Thread Brage
A minor feature request: PostgreSQL supports ISO-8601 week numbers with the syntax EXTRACT(WEEK FROM timestamp) or TO_CHAR(timestamp,'IW'). There is, however, no easy way to extract the year corresponding to the week number. Since ISO weeks may overlap year boundaries, this makes the week number