On Mon, Dec 1, 2014 at 2:32 PM, <rob@xxxxxxxxx> wrote:
I wonder if there should be a YEAR_ISO function.

I think there should be. In Python, date and datetime objects have a
method called isocalendar() which returns a tuple consisting of the
ISO year, ISO week number, and ISO weekday.

It's necessary to provide all three numbers to uniquely identify a
date, just as it's necessary to provide the year, month, and day when
specifying a Gregorian calendar date.

I was thinking of grouping over more than one year.
... where WEEK_ISO=x and YEAR_ISO=y...
kind of thing.

Right. How can you compare year-over-year (to take just one example)
if you can't tell what year your data is in? I guess maybe using ISO
weeks for such things Just Isn't Done? (I wouldn't know; we don't use
ISO weeks at all where I work. Actually, I don't know if anyone else
in the company has even heard of ISO week numbers.)

John Y.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].