Re: Find all the dates in the calendar week?

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Helge Haugland <helland(at)geocities(dot)com>
Cc: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: Find all the dates in the calendar week?
Date: 2000-07-07 05:40:48
Message-ID: 39656D60.45A34480@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > ISO-week: week that has more than 4 day and start in Sunday.
> What about weeks that start in Monday (as here in Norway)?

You can probably calculate that from the existing date/time code. But it
isn't ISO-8601. Karel was referring to the ISO-defined week for which
the first week of the year is that week which contains a Thursday. It
has the rather strange outcome that for some years, days in the previous
or subsequent calendar year fall into the adjacent "ISO-year".

- Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2000-07-07 07:01:33 Re: Find all the dates in the calendar week?
Previous Message Thomas Lockhart 2000-07-07 05:32:38 Re: PostgreSQL & the BSD License