X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E55C5564E8 for ; Tue, 15 Mar 2005 14:06:39 +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 47582-07 for ; Tue, 15 Mar 2005 14:06:35 +0000 (GMT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 1461956487 for ; Tue, 15 Mar 2005 14:06:31 +0000 (GMT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Tue Mar 15 15:06:27 2005 +0100 Received: from rodos.fzk.de (resy6.fzk.de [141.52.68.10]) by resy5.fzk.de (8.12.7/8.12.7/SuSE Linux 0.6) with ESMTP id j2FE6JsG023880; Tue, 15 Mar 2005 15:06:24 +0100 Message-ID: <4236EBDA.5012F012@rodos.fzk.de> Date: Tue, 15 Mar 2005 15:06:18 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: Kenneth Gonsalves Cc: PostgreSQL SQL Subject: Re: outputting dates References: <200503140917.34875.lawgon@thenilgiris.com> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS - amavis-milter (http://www.amavis.org/) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/221 X-Sequence-Number: 20700 Kenneth Gonsalves wrote: > > hi, > i have set my datetype to 'European, SQL'. This correctly accepts > dates of the form dd/mm/yyyy. However, the output is still in the > 'yyyy-mm-dd' format. How do i get the default output as dd/mm/yyyy? > -- > regards > kg > I have select version(); version ------------------------------------------------------------------------------------- PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (SuSE Linux) I did set datestyle to 'European, SQL'; SET select date_trunc( 'day' , now() ); date_trunc ------------------------- 15/03/2005 00:00:00 CET How did you set your datetype? Regards, Christoph