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 2825F3A52B9 for ; Mon, 24 Jan 2005 16:47:51 +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 60269-08 for ; Mon, 24 Jan 2005 16:47:41 +0000 (GMT) Received: from mail.zerosoft.ro (main.zerosoft.ro [193.226.89.14]) by svr1.postgresql.org (Postfix) with ESMTP id 581AF3A5574 for ; Mon, 24 Jan 2005 16:47:36 +0000 (GMT) Received: from 192.168.16.10 by mail.zerosoft.ro ([192.168.16.1] running VPOP3) with SMTP for ; Mon, 24 Jan 2005 18:47:33 +0200 Message-ID: <001401c50234$66a0b410$0a10a8c0@zerosoft.ro> Reply-To: "Raul Secan" From: "Raul Secan" To: Subject: to_char replacement Date: Mon, 24 Jan 2005 18:47:33 +0200 Organization: ZEROSOFT MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01C50245.2A205C50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Server: VPOP3 V1.4.5 - Registered to: ZeroSoft X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.078 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/2 X-Sequence-Number: 2972 This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C50245.2A205C50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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? ------=_NextPart_000_0011_01C50245.2A205C50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello, since = to_char() function=20 will no longer be available from PostgreSQL 8.1 ... I might need to = change=20 that from my scripts.
 
For example I had = something like=20 that, which you can see returns the day in the format I = need:
 
SELECT = TO_CHAR(some_date,=20 'DD-MM-YYYY') FROM some_table;
 
Is there anyway to do = that without=20 TO_CHAR?
------=_NextPart_000_0011_01C50245.2A205C50--