ISO week and extract(dow from source)

From: Clodoaldo Pinto <clodoaldo_pinto(at)yahoo(dot)com(dot)br>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: ISO week and extract(dow from source)
Date: 2004-12-02 12:34:38
Message-ID: 20041202123438.94691.qmail@web40912.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From the 7.4.2 manual, Date/Time Functions and operators, 9.8.1. EXTRACT,
date_part:

week:
(The ISO-8601 week starts on Monday.)

dow:
The day of the week (0 - 6; Sunday is 0)

Why is Sunday dow 0, if the iso week starts on Monday and the iso week is used
in extract(week from source)?

Clodoaldo Pinto




_______________________________________________________
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/

Browse pgsql-general by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-12-02 12:42:56 Re: Poor Performance with Distinct Subqueries with EXISTS and EXCEPT
Previous Message Magnus Hagander 2004-12-02 10:19:29 Re: Pl/Perl w/ Postgres 8.0 on Windows