Received: from neptun.sns-felb.debis.de (neptun.sns-felb.debis.de [53.122.101.2]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f037SJ758984 for ; Wed, 3 Jan 2001 02:28:19 -0500 (EST) (envelope-from jhartwig@debis.com) Received: by neptun.sns-felb.debis.de; id IAA07230; Wed, 3 Jan 2001 08:33:28 +0100 Received: from unknown(53.113.82.10) by neptun.sns-felb.debis.de via smap (V5.0) id xma007217; Wed, 3 Jan 01 08:33:26 +0100 Received: from mail1.b3.dsh.de (localhost [127.0.0.1]) by dshmail1.dsh.de (8.9.1/8.8.7) with ESMTP id IAA13440; Wed, 3 Jan 2001 08:31:12 +0100 (MET) Received: from debis.com ([138.201.143.121]) by mail1.b3.dsh.de (8.10.0/8.10.0) with ESMTP id f037Sm524961; Wed, 3 Jan 2001 08:28:48 +0100 Message-ID: <3A52D50A.416A0C38@debis.com> Date: Wed, 03 Jan 2001 08:30:18 +0100 From: Jens Hartwig Organization: debis Systemhaus GEI X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de MIME-Version: 1.0 To: Leo Xavier CC: pgsql-sql@postgresql.org Subject: Re: order by day or month, etc References: <001201c0751b$39405ca0$8902a8c0@centro.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/27 X-Sequence-Number: 688 Hello Leo, which version of PostgreSQL are you running? I tested: select to_char(abm_dat, 'DD/MM/YYYY') AS new_date from t_dummy; And it works fine: new_date ------------ 31/03/1992 15/06/1994 11/09/1993 19/11/1993 ... Regards, Jens Leo Xavier schrieb: > [...] > doing this: > SELECT to_char(field, 'DD/MM/YYYY') AS new_date > > as Francis Solomon said, didnt work... "unrecognized function" ... > [...] ============================================= Jens Hartwig --------------------------------------------- debis Systemhaus GEI mbH 10875 Berlin Tel. : +49 (0)30 2554-3282 Fax : +49 (0)30 2554-3187 Mobil : +49 (0)170 167-2648 E-Mail : jhartwig@debis.com =============================================