Re: Working with dates and queries

On Thu, 13 Sep 2001, Krog, Kenneth wrote:
> > I am attempting to do a query for a specific month based of a response for
> > a web site using php as the engine.
> > The syntax of the sql is simple
> >
> > "SELECT * FROM table WHERE MONTH(fieldname)=08;"
> >
> > note:
> > the fieldname is set to be a date field.
> >
> > Is this correct postgre syntax to find a date by month?
> >
> > If so: the fieldname I used was "date" since it is a researved word will
> > this cause problems?
> > If not what is the correct syntax?

I think this will work for you...

SELECT * FROM table WHERE
EXTRACT(MONTH FROM "date")=8;