Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0NGJG073340 for ; Tue, 23 Jan 2001 11:19:16 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0NGJ4906399; Tue, 23 Jan 2001 11:19:04 -0500 (EST) To: "Graham Vickrage" cc: pgsql-sql@postgresql.org Subject: Re: grouping by date increments In-reply-to: References: Comments: In-reply-to "Graham Vickrage" message dated "Tue, 23 Jan 2001 11:41:40 +0000" Date: Tue, 23 Jan 2001 11:19:04 -0500 Message-ID: <6396.980266744@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/296 X-Sequence-Number: 965 "Graham Vickrage" writes: > I have written this successfully but need to get the count in time > increments such as per day/week/month. Perhaps use GROUP BY date_part(...). See stgresql.org/devel-corner/docs/postgres/functions-datetime.htm for doco on date_part(). regards, tom lane