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 2BB55564B4 for ; Wed, 9 Mar 2005 12:23:02 +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 94530-02 for ; Wed, 9 Mar 2005 12:22:53 +0000 (GMT) Received: from relay.mixmail.com (relay01.mixmail.com [62.151.8.30]) by svr1.postgresql.org (Postfix) with ESMTP id C3284564A5 for ; Wed, 9 Mar 2005 12:22:51 +0000 (GMT) Received: from [172.30.8.14] (helo=web06) by relay.mixmail.com with smtp id 1D90DF-0006f0-00 for pgsql-php@postgresql.org; Wed, 09 Mar 2005 13:22:53 +0100 Date: Wed, 09 Mar 2005 07:22:53 -0500 From: "enzo venegas palacios" Reply-To: enzovenegas@mixmail.com To: "pgsql-php@postgresql.org" Subject: format query Xmailer: Mixmail Server 3.0 X-Priority: 3 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: quoted-printable Message-Id: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.158 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, PRIORITY_NO_NAME, TO_ADDRESS_EQ_REAL X-Spam-Level: ** X-Archive-Number: 200503/29 X-Sequence-Number: 3044 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 =3D 01. but i don't know the specific query I hope somebody can help me. enzo --------------------------------------------------------- ¿Quieres saber cómo te ira en el amor? ¿en el trabajo? Nosotros te lo contamos http://astrocentro.mujeractual.com/ya ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/