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
databy month. Monthday> > > and year arent' important, those I can't give from perl script, but what> > > I do give to
postgresare 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
andlacking explanation of> > > date_trunc.> > > Antti> > >> > >> >>
