Re: day of week

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