Received: from linux2.johnmckown.net (adsl-64-216-13-43.dsl.eulstx.swbell.net [64.216.13.43]) by hub.org (8.10.1/8.10.1) with ESMTP id e73JM3G62648 for ; Thu, 3 Aug 2000 15:22:03 -0400 (EDT) Received: from linux2 (IDENT:jmckown@linux2 [192.168.151.21]) by linux2.johnmckown.net (8.10.1/8.10.1) with ESMTP id e73JNYh30832 for ; Thu, 3 Aug 2000 14:23:34 -0500 Date: Thu, 3 Aug 2000 14:23:34 -0500 (CDT) From: John McKown X-Sender: jmckown@linux2.johnmckown.net To: pgsql-sql@postgresql.org Subject: Re: Extracting data by months In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200008/30 This might seem rather silly, but could you simply do something like: select * from database where date_field >= '01/01/2000'::date and date_field < '02/01/2000'::date; Of course, if date_field could contain many different years, then this would not get you the result you wanted. John On Thu, 3 Aug 2000, Antti Linno wrote: > Lo. > > I'm in dire need of knowledge, how to extract data by month. Monthday > and year arent' important, those I can't give from perl script, but what > I do give to postgres are the numbers of the months. Date field is in > timestamp. I thought about date_trunc, but I can't think of, how to get > data with it. In script will be 12 queries, for each month, to get the > news from that month. > Btw, is there somewhere a manual about date_trunc, the docs that come with > RH6.1 distribution are somewhat short and lacking explanation of > date_trunc. > Antti > >