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 39696726.64F9F41D@alumni.caltech.edu
Whole thread Raw
In response to Re: Find all the dates in the calendar week?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
> > ISO-year/week-of-year is a business-only construct, perhaps helping with
> > payment intervals.
> Aren't people using databases to run businesses, perhaps even payment
> systems? I know I do.

I think we got off on the wrong foot on this discussion. I'm not arguing
for or against anything, just trying to clarify what we have and will
have in the future. afaik nothing existing or proposed is at odds with
any national or international standard.

In particular, "week of year" is defined in ISO-8601, and I'm not
remembering any other standard or convention which would specify an
incompatible definition of this concept. The "year" associated with
"week of year" is not guaranteed to coincide with the common-usage
"calendar year", but that is specified in the standard.

                       - Thomas

pgsql-general by date:

Previous
From: "Robert J. Sprawls"
Date:
Subject: Linking to palloc and elog. (fwd)
Next
From: Tom Lane
Date:
Subject: Re: Linking to palloc and elog. (fwd)