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 22F4F5288E for ; Tue, 14 Jun 2005 16:58:26 -0300 (ADT) 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 64991-09 for ; Tue, 14 Jun 2005 19:58:18 +0000 (GMT) Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by svr1.postgresql.org (Postfix) with ESMTP id F20C5528BF for ; Tue, 14 Jun 2005 16:58:16 -0300 (ADT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 22852103C4; Tue, 14 Jun 2005 12:58:18 -0700 (PDT) From: Steve Crawford Organization: Pinpoint Research To: =?iso-8859-1?q?=C2ngelo=20Marcos=20Rigo?= , pgsql-php@postgresql.org Subject: Re: formating dates Date: Tue, 14 Jun 2005 12:58:17 -0700 User-Agent: KMail/1.5.1 References: <20050614194425.18990.qmail@web33707.mail.mud.yahoo.com> In-Reply-To: <20050614194425.18990.qmail@web33707.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200506141258.17102.scrawford@pinpointresearch.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.07 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/4 X-Sequence-Number: 3163 On Tuesday 14 June 2005 12:44 pm, =C2ngelo Marcos Rigo wrote: > Hi can i format dates from postgresql stored in the > aaa-mm-dd format to June 14 2005 - Tuesday ? > > using just postgresql functions? select to_char(now(), 'FMMonth dd yyyy - FMDay'); See to_char() documentation for more. Cheers, Steve