X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B54DF56489 for ; Wed, 9 Mar 2005 12:38:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96919-10 for ; Wed, 9 Mar 2005 12:38:08 +0000 (GMT) Received: from tomts16-srv.bellnexxia.net (tomts16.bellnexxia.net [209.226.175.4]) by svr1.postgresql.org (Postfix) with ESMTP id 208865645A for ; Wed, 9 Mar 2005 12:38:07 +0000 (GMT) Received: from acer.sympatico.ca ([65.95.170.130]) by tomts16-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with ESMTP id <20050309123810.RZQT1836.tomts16-srv.bellnexxia.net@acer.sympatico.ca> for ; Wed, 9 Mar 2005 07:38:10 -0500 Message-Id: <5.2.1.1.0.20050309073647.00aaae00@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Wed, 09 Mar 2005 07:37:40 -0500 To: "pgsql-php@postgresql.org" From: Frank Bax Subject: Re: format query In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.272 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200503/30 X-Sequence-Number: 3045 At 07:22 AM 3/9/05, enzo venegas palacios wrote: >I am trying to build a query sql that select all rows in my table with a >spesific month (format timestamp, yyy-mm-dd hh:mm:ss), for example, all of >january, select * from table where field_date = 01. >but i don't know the specific query WHERE date_part('month',field_date) = 01