On Wed, Mar 14, 2001 at 01:23:30PM -0500, Roland Roberts wrote:
> > "AZ" == Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
>
> >> Unix day-of-week starts on Sunday, not Monday, which is what
> >> date_trunc('dow',...) returns. Presumably this is modeled on
> >> the traditional
> traditional notion (at least in the US; I suspect this is true in most
> European countries at least) of Sunday being "the first day of week".
I believe that in most European countries, Monday is the first day of the
week.
--
Kaare Rasmussen--Linux, spil,--Tlf:38
> "AZ" == Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
>> Unix day-of-week starts on Sunday, not Monday, which is what
>> date_trunc('dow',...) returns. Presumably this is modeled on
>> the traditional notion (at least in the US; I suspect this is
>> true in most Europea
> "Peter" == Peter Eisentraut <[EMAIL PROTECTED]> writes:
Peter> The POSIX numbering (0-6) is actually pretty slick because
Peter> it allows both versions to work: In the U.S. (e.g.) you get
Peter> a natural order starting at 0, in Germany (e.g.) you get
Peter> Monday as #1.
On Wed, Mar 14, 2001 at 07:02:41PM +0100, Peter Eisentraut wrote:
> Jim Mercer writes:
> > most western calendars that i have seen show "Sun Mon Tue Wed Thu Fri Sat".
>
> Most *English* calendars you have seen, I suppose. In Germany there is no
> such possible calendar. If you printed a calenda
Jim Mercer writes:
> most western calendars that i have seen show "Sun Mon Tue Wed Thu Fri Sat".
Most *English* calendars you have seen, I suppose. In Germany there is no
such possible calendar. If you printed a calendar that way, it would be
considered a printo. The same is true in most part
On Wed, Mar 14, 2001 at 04:54:54PM +0100, Zeugswetter Andreas SB wrote:
> > Unix day-of-week starts on Sunday, not Monday, which is what
> > date_trunc('dow',...) returns. Presumably this is modeled on the
> > traditional notion (at least in the US; I suspect this is true in most
> > European coun
> Unix day-of-week starts on Sunday, not Monday, which is what
> date_trunc('dow',...) returns. Presumably this is modeled on the
> traditional notion (at least in the US; I suspect this is true in most
> European countries at least) of Sunday being "the first day of week".
Germany and Austria h
On Wed, Mar 14, 2001 at 02:50:35PM +, Thomas Lockhart wrote:
> > First day in week is Monday in ISO week.
> > Thomas, we have ISO week-of-year (IW in to_char or 'week' in date_part),
> > but we haven't ISO day-of-week (may be as 'ID' for to_char).
> > TODO for 7.2?
> > ..but in ISO is 0-6; 0
> First day in week is Monday in ISO week.
> Thomas, we have ISO week-of-year (IW in to_char or 'week' in date_part),
> but we haven't ISO day-of-week (may be as 'ID' for to_char).
> TODO for 7.2?
> ..but in ISO is 0-6; 0=Mon
I've been ignoring this until now, hoping no one would notice ;)
Uni
10 matches
Mail list logo
