Postgres Pro
Downloads
Home   >   mailing lists

Re: Find all the dates in the calendar week? - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: Find all the dates in the calendar week?
Date
Msg-id 39656D60.45A34480@alumni.caltech.edu
Whole thread Raw
In response to RE: Find all the dates in the calendar week?  ("Andrew Snow" <als@fl.net.au>)
Responses Re: Find all the dates in the calendar week?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
Tree view 
> > 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

pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: PostgreSQL & the BSD License
Next
From: Karel Zak
Date:
Subject: Re: Find all the dates in the calendar week?