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 4367D3A5572 for ; Mon, 24 Jan 2005 17:18:20 +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 67940-05 for ; Mon, 24 Jan 2005 17:18:10 +0000 (GMT) Received: from server.cityscape3d.com (unknown [217.206.144.18]) by svr1.postgresql.org (Postfix) with ESMTP id 199763A5534 for ; Mon, 24 Jan 2005 17:18:08 +0000 (GMT) Received: from [192.168.1.117] ([192.168.1.117]) by server.cityscape3d.com (8.12.11/8.11.6) with ESMTP id j0OGvPS1077010; Mon, 24 Jan 2005 16:57:27 GMT (envelope-from chriskl@familyhealth.com.au) Received: from 127.0.0.1 (AVG SMTP 7.0.302 [265.7.2]); Mon, 24 Jan 2005 17:17:15 +0000 Message-ID: <41F52D9B.7070209@familyhealth.com.au> Date: Mon, 24 Jan 2005 17:17:15 +0000 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Raul Secan Cc: pgsql-php@postgresql.org Subject: Re: to_char replacement References: <001401c50234$66a0b410$0a10a8c0@zerosoft.ro> In-Reply-To: <001401c50234$66a0b410$0a10a8c0@zerosoft.ro> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.02 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/3 X-Sequence-Number: 2973 to_char() will still be around for dates, just not for intervals. You have nothing to worry about. Chris Raul Secan wrote: > > Hello, since to_char() function will no longer be available from > PostgreSQL 8.1 ... I might need to change that from my scripts. > > For example I had something like that, which you can see returns the day > in the format I need: > > SELECT TO_CHAR(some_date, 'DD-MM-YYYY') FROM some_table; > > Is there anyway to do that without TO_CHAR?