Re: Find all the dates in the calendar week?

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Find all the dates in the calendar week?
Date: 2000-07-10 06:03:18
Message-ID: 39696726.64F9F41D@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bitmead 2000-07-10 06:19:12 Re: Slashdot discussion
Previous Message Tom Lane 2000-07-10 06:01:23 Re: Linking to palloc and elog. (fwd)