Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 515F09FB2C4 for ; Mon, 5 Mar 2007 02:14:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 14632-01 for ; Mon, 5 Mar 2007 02:14:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 2DE709FB286 for ; Mon, 5 Mar 2007 02:14:36 -0400 (AST) Received: from [192.168.178.99] (p548B21BD.dip0.t-ipconnect.de [84.139.33.189]) by service-web.de (Postfix) with ESMTP id D7D20200099; Mon, 5 Mar 2007 07:14:33 +0100 (CET) Message-ID: <45EBB548.5090502@wildenhain.de> Date: Mon, 05 Mar 2007 07:14:32 +0100 From: Tino Wildenhain User-Agent: Thunderbird 1.5.0.5 (X11/20060728) MIME-Version: 1.0 To: Garry Saddington Cc: pgsql-general@postgresql.org Subject: Re: date format References: <200703041247.05097.garry@schoolteachers.co.uk> In-Reply-To: <200703041247.05097.garry@schoolteachers.co.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.201 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/243 X-Sequence-Number: 110433 Garry Saddington schrieb: > I have 'datestyle ISO,DMY' set in postgresql.conf but the date output is still > rendered in the format (y,m,d) . How can I change this behaviour? > regards > garry > See my answer on the Zope list. The style however influences the way dates are parsed by default, so you need to take care when you feed dates from your application to database. You should also use to_date() to make it explicit. Regards Tino