Re: day of week - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: day of week
Date
Msg-id Pine.LNX.4.21.0006060419560.3694-100000@localhost.localdomain
Whole thread Raw
In response to Re: day of week  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: day of week
List pgsql-hackers
Karel Zak writes:

> The date_part() say that monday is a first day, to_char that it is
> second day, and what will say date_trunc()? --- how date is a week
> start, 'monday' or 'sunday' date ?

In a perfect world, the answer would be locale dependent.

In many implementations Sunday is the first day of the week but counting
starts with 0, so you still get Monday as "1".


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Protection of debugging options
Next
From: Peter Eisentraut
Date:
Subject: Re: ODBC configure