Received: from dcave.digsys.bg (root@dcave.digsys.bg [192.92.129.5]) by hub.org (8.10.1/8.10.1) with ESMTP id e74DOqG31307 for ; Fri, 4 Aug 2000 09:24:53 -0400 (EDT) Received: from dcave.digsys.bg (daniel@localhost.digsys.bg [127.0.0.1]) by dcave.digsys.bg (8.9.3/8.9.3) with ESMTP id QAA13602; Fri, 4 Aug 2000 16:24:03 +0300 (EEST) Message-Id: <200008041324.QAA13602@dcave.digsys.bg> X-Mailer: exmh version 2.1.0 09/18/1999 To: "Sandis" cc: pgsql-sql@postgresql.org Subject: Re: Extracting data by months In-reply-to: Your message of "Fri, 04 Aug 2000 10:40:43 +0300." <000a01bffde7$4bb21d20$d17b02c3@mediaparks.lv> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Fri, 04 Aug 2000 16:24:01 +0300 From: Daniel Kalchev X-Archive-Number: 200008/40 This is not exactly what the original question was about. You select the month is one specific year only. What you do it however easier achieved by: SELECT datums FROM jaunumi WHERE date_trunc('month', datums) = '2000-08-01'; datetime is an type full of tricks. :-) Daniel >>>"Sandis" said: > I do it like this: > > SELECT datums FROM jaunumi > WHERE date_part('year',datetime(datums)) = '2000' AND > date_part('month',datetime(datums)) = '08'; > > Where datums is a timestamp field. > > Regards, > Sandis Jerics > www.mediaparks.lv > > > 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 > > > > > > > > >