Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 688204761B8 for ; Thu, 24 Oct 2002 07:08:11 -0400 (EDT) Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (Postfix) with ESMTP id 3E55947618E for ; Thu, 24 Oct 2002 07:08:10 -0400 (EDT) Received: from ara.zf.jcu.cz (LOCALHOST [127.0.0.1]) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) with ESMTP id g9OB8Bhb008150; Thu, 24 Oct 2002 13:08:11 +0200 Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) id g9OB8Bjf008149; Thu, 24 Oct 2002 13:08:11 +0200 Date: Thu, 24 Oct 2002 13:08:11 +0200 From: Karel Zak To: Andreas Joseph Krogh Cc: pgsql-sql@postgresql.org Subject: Re: Problems with to_char(created, 'WW') Message-ID: <20021024130811.D13536@zf.jcu.cz> References: <200210241251.35365.andreak@officenet.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200210241251.35365.andreak@officenet.no>; from andreak@officenet.no on Thu, Oct 24, 2002 at 12:51:35PM +0200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/332 X-Sequence-Number: 10049 On Thu, Oct 24, 2002 at 12:51:35PM +0200, Andreas Joseph Krogh wrote: > > janerik=# select created, to_char(created, 'WW') as week from session WHERE > username IS NULL ORDER BY week; Please, see docs and 'IW' (ISO week). Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz