Re: Find all the dates in the calendar week?

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


On Fri, 7 Jul 2000, Thomas Lockhart wrote:

> > > 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".
>

Is anywhere on net available see this ISO date/time definition?


Karel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Heaven 2000-07-07 07:57:37 'Zombie' tables
Previous Message Karel Zak 2000-07-07 07:01:33 Re: Find all the dates in the calendar week?