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 7EF005282B for ; Tue, 14 Jun 2005 16:52:39 -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 67870-01 for ; Tue, 14 Jun 2005 19:52:30 +0000 (GMT) Received: from zhonka1.zhonka.net (zhonka1.zhonka.net [66.228.195.5]) by svr1.postgresql.org (Postfix) with ESMTP id B16EE528BF for ; Tue, 14 Jun 2005 16:52:27 -0300 (ADT) Received: from wolf.pjkh.com ([66.228.196.74]) by zhonka1.zhonka.net (Post.Office MTA v3.5.3 release 223 ID# 0-58414U4500L450S0V35) with ESMTP id net; Tue, 14 Jun 2005 12:52:28 -0700 Received: from localhost (localhost [127.0.0.1]) by wolf.pjkh.com (Postfix) with ESMTP id 1434558C7; Tue, 14 Jun 2005 12:52:23 -0700 (PDT) Received: from wolf.pjkh.com ([127.0.0.1]) by localhost (wolf.pjkh.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32127-07; Tue, 14 Jun 2005 12:52:22 -0700 (PDT) Received: by wolf.pjkh.com (Postfix, from userid 1000) id C49FF58C6; Tue, 14 Jun 2005 12:52:22 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by wolf.pjkh.com (Postfix) with ESMTP id BC7E858C5; Tue, 14 Jun 2005 12:52:22 -0700 (PDT) Date: Tue, 14 Jun 2005 12:52:22 -0700 (PDT) From: Philip Hallstrom To: =?iso-8859-1?q?=C2ngelo=20Marcos=20Rigo?= Cc: pgsql-php@postgresql.org Subject: Re: formating dates In-Reply-To: <20050614194425.18990.qmail@web33707.mail.mud.yahoo.com> Message-ID: <20050614125212.U32639@wolf.pjkh.com> References: <20050614194425.18990.qmail@web33707.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at pjkh.com X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/3 X-Sequence-Number: 3162 > Hi can i format dates from postgresql stored in the > aaa-mm-dd format to June 14 2005 - Tuesday ? > > using just postgresql functions? Yes. http://www.postgresql.org/docs/7.4/interactive/functions-formatting.html