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 70F235650A for ; Wed, 9 Mar 2005 13:10:08 +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 05497-08 for ; Wed, 9 Mar 2005 13:09:57 +0000 (GMT) Received: from smtp816.mail.sc5.yahoo.com (smtp816.mail.sc5.yahoo.com [66.163.170.2]) by svr1.postgresql.org (Postfix) with SMTP id 627C0564E9 for ; Wed, 9 Mar 2005 13:09:55 +0000 (GMT) Received: from unknown (HELO Todd) (lewis-todd@sbcglobal.net@69.149.80.241 with login) by smtp816.mail.sc5.yahoo.com with SMTP; 9 Mar 2005 13:09:57 -0000 From: "Todd Lewis" To: enzovenegas@mixmail.com, "pgsql-php@postgresql.org" Date: Wed, 09 Mar 2005 07:07:57 -0800 MIME-Version: 1.0 Subject: Re: format query Message-ID: <422EA0CD.3616.7C54045@localhost> In-reply-to: X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Content-description: Mail message body X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.75 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200503/31 X-Sequence-Number: 3046 use the to_char function to specify the format in your where clause. > > 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 > --------------------------------------------------------- > =BFQuieres saber c=F3mo te ira en el amor? =BFen el trabajo? Nosotros te= lo contamos http://astrocentro.mujeractual.com/ya > ADSL + Llamadas 24 horas: desde 28,95 =80/mes + IVA. Navega y habla de f= orma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLll= amadas/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster