Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5C61E476444
	for <pgsql-sql@postgresql.org>; Thu, 24 Oct 2002 07:13:01 -0400 (EDT)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id AE1A847638E
	for <pgsql-sql@postgresql.org>; Thu, 24 Oct 2002 07:13:00 -0400 (EDT)
Received: from klaster.net (pt207.krakow.cvx.ppp.tpnet.pl [217.99.216.207])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 3949D2B4D6; Thu, 24 Oct 2002 13:06:19 +0200 (CEST)
Message-ID: <3DB7D72E.1020700@klaster.net>
Date: Thu, 24 Oct 2002 13:19:10 +0200
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problems with to_char(created, 'WW')
References: <200210241251.35365.andreak@officenet.no>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/333
X-Sequence-Number: 10050

Uz.ytkownik Andreas Joseph Krogh napisa?:
> 
> Now - my question is, why is monday 21. in week 42, but tuesday 22. in week 
> 43?

Read the documentation - 4.7. Data Type Formatting Functions
"WW - week number of year (1-53) where first week start on the first day 
of the year"

Year 2002 started on Tuesday, so monday is still week 42, but tuesday is 
week 43.

Tomasz Myrta