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 3CCB7564A3 for ; Fri, 18 Mar 2005 01:48:40 +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 52531-04 for ; Fri, 18 Mar 2005 01:48:30 +0000 (GMT) Received: from smtp812.mail.sc5.yahoo.com (smtp812.mail.sc5.yahoo.com [66.163.170.82]) by svr1.postgresql.org (Postfix) with SMTP id C2E735440A for ; Fri, 18 Mar 2005 01:48:28 +0000 (GMT) Received: from unknown (HELO ?192.168.0.101?) (lewis-todd@sbcglobal.net@70.242.208.180 with plain) by smtp812.mail.sc5.yahoo.com with SMTP; 18 Mar 2005 01:48:31 -0000 Message-ID: <423A4F9A.6090509@sbcglobal.net> Date: Thu, 17 Mar 2005 19:48:42 -0800 From: Todd Lewis User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: enzovenegas@mixmail.com Cc: "pgsql-php@postgresql.org" Subject: Re: a new question References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit 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/47 X-Sequence-Number: 3062 you can use to_char(timestamp,'mm-dd-yyy') where timestamp is your couln name. You can place this in your select section. enzo venegas palacios wrote: >hi, my problem is very basic (and my english too) > >i have a variable with a date (timestamp format) >$fecha = mm-dd-yyy hh:mm:ss > >i need to display only the date and not the hour > >$only_date = ??? ($fecha); > >echo $only_date; >display = mm-dd-aaaa > > >enzo >--------------------------------------------------------- >Redecora tu móvil. Redecora tu vida. ¿Por qué no? Con http://logos.ya.com es posible >ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/ > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > >