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 4DFAA52AA9 for ; Fri, 25 Feb 2005 23:20:49 +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 85661-09 for ; Fri, 25 Feb 2005 23:20:47 +0000 (GMT) Received: from tetra.ehpg.net (tetra.ehpg.net [216.218.206.34]) by svr1.postgresql.org (Postfix) with ESMTP id 0C9D652A61 for ; Fri, 25 Feb 2005 23:20:46 +0000 (GMT) Received: from 65-60-114-26-cust.telepacific.net ([65.60.114.26] helo=gmr-dev.cloud.glyphix.com) by tetra.ehpg.net with esmtpa (Exim 4.43) id 1D4olg-0002UD-LF; Fri, 25 Feb 2005 15:21:10 -0800 Subject: Re: save wiht time format From: "Gavin M. Roy" To: enzovenegas@mixmail.com Cc: "pgsql-php@postgresql.org" In-Reply-To: References: Content-Type: text/plain Date: Fri, 25 Feb 2005 15:24:54 -0800 Message-Id: <1109373894.15480.17.camel@gmr-dev.cloud.glyphix.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/34 X-Sequence-Number: 3008 If you use a timestamp field (or date field) you can format the output using the to_char function. The PgSQL docs have to_char very well documented. On Fri, 2005-02-25 at 18:11 -0500, enzo venegas palacios wrote: > does anyone know how to save a date in postgres where my_ table have > format time. or to change this format. > thanks, > > enzo > --------------------------------------------------------- > Abnate a la primitiva. Descubre la forma ms fcil y cmoda de hacerse millonario. htp://sorteos.ya.com > 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 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match