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 BE6B452A50 for ; Fri, 18 Mar 2005 22:07:07 +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 60624-08 for ; Fri, 18 Mar 2005 22:07:04 +0000 (GMT) Received: from outmx009.isp.belgacom.be (outmx009.isp.belgacom.be [195.238.3.4]) by svr1.postgresql.org (Postfix) with ESMTP id D8235569A3 for ; Fri, 18 Mar 2005 22:07:02 +0000 (GMT) Received: from outmx009.isp.belgacom.be (localhost [127.0.0.1]) by outmx009.isp.belgacom.be (8.12.11/8.12.11/Skynet-OUT-2.22) with ESMTP id j2IM72Lw000752 for ; Fri, 18 Mar 2005 23:07:02 +0100 (envelope-from ) Received: from 140-232.242.81.adsl.skynet.be (140-232.242.81.adsl.skynet.be [81.242.232.140]) by outmx009.isp.belgacom.be (8.12.11/8.12.11/Skynet-OUT-2.22) with ESMTP id j2IM6w31000729 for ; Fri, 18 Mar 2005 23:06:59 +0100 (envelope-from ) Subject: Re: a new question From: Bastiaan Wakkie Reply-To: bastiaan@wakkie.org To: pgsql-php@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset=ISO-8859-15 Date: Fri, 18 Mar 2005 23:07:06 +0100 Message-Id: <1111183626.22520.5.camel@wakkie.org> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3-1.1.101mdk Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/49 X-Sequence-Number: 3064 Hi enzo, In your select statement you do this: SELECT date_part('MONTH',date) as month, date_part('DAY',date) as day, date_part('YEAR',date) as year ... then in php the following: displayDate = month."-".day."-".year Cheers, -- ^(B(astia{2}n)?)(\s)?(W(ak{2}ie)?)$ On Thu, 2005-03-17 at 18:35 -0500, 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