RE: day of week

From: Magnus Hagander <mha(at)sollentuna(dot)net>
To: "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: Don Baccus <dhogaza(at)pacifier(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: day of week
Date: 2000-06-08 07:47:02
Message-ID: 215896B6B5E1CF11BC5600805FFEA82103046729@sirius.edu.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Karel Zak writes:
>
> > The Oracle always directly set first week on Jan-01, but
> day-of-week count
> > correct... It is pretty dirty, but it is a probably set in
> libc's mktime().
>
> The first week of the year is most certainly not (always) the
> week with
> Jan-01 in it. My understanding is that it's the first week where the
> Thursday is in the new year, but I might be mistaken. Here in
> Sweden much
> of the calendaring is done based on the week of the year
> concept, so I'm
> pretty sure that there's some sort of standard on this. And
> sure enough,
> this year started on a Saturday, but according to the
> calendars that hang
> around here the first week of the year started on the 3rd of January.

In Sweden (and several other places), "Week 1" is defined as "the first week
that has at least four days in the new year".

While it's not an authority, my MS Outlook Calendar allows me to chose from:
"Starts on Jan 1", "First 4-day week" and "First full week".
So it would seem there are at least these three possibilities.

//Magnus

Browse pgsql-hackers by date

  From Date Subject
Next Message Giles Lean 2000-06-08 07:57:06 Re: [BUGS] Re: Sigh, LIKE indexing is *still* broken in foreign locales
Previous Message Hiroshi Inoue 2000-06-08 07:28:56 RE: DROP COLUMN status