Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2B0439FB685 for ; Sun, 4 Mar 2007 08:58:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 01560-05-4 for ; Sun, 4 Mar 2007 08:58:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by postgresql.org (Postfix) with ESMTP id 4198A9FB405 for ; Sun, 4 Mar 2007 08:58:53 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so1339612wxd for ; Sun, 04 Mar 2007 04:58:52 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:received:received:received:received:from:to:cc:subject:in-reply-to:references:date:message-id:user-agent:mime-version:content-type:x-virus-scanned; b=m+JGphvyjkoA/yq8eEM9QsOjKQa7Unsx6BtrIqWt7umEjjg50E8jIYYs0kDrbQXBgEyrtCi6FXau6Zl31K2KVWiYx82rg4WmpLEC/iu30XmVltp7yX2atI/tuIChX+NR0TSAe/NH2vaNIe/MHgbaywbTUP7WDot9uFKy5CSWL/s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:cc:subject:in-reply-to:references:date:message-id:user-agent:mime-version:content-type:x-virus-scanned; b=aJwki2GFWe17P6tW2T5+N0J4bGdLLnYILLz/+FMTkE1QwZdGS3XW6DNWc0roQjsV+MfnvIkE0DL6/Ti/KfVhwBE+RpEiWfuVoyA+JSdTHIFhd0PRJmTFYdqFaIcUkZQr3+T6sQRuPxLmf286JCxjCcKS/faeZJ1k3kSS1vSaVJM= Received: by 10.70.74.1 with SMTP id w1mr7939883wxa.1173013132035; Sun, 04 Mar 2007 04:58:52 -0800 (PST) Received: from strongwill.g2ctech ( [201.47.8.134]) by mx.google.com with ESMTP id 10sm7329755wrl.2007.03.04.04.58.50; Sun, 04 Mar 2007 04:58:51 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by strongwill.g2ctech (Postfix) with ESMTP id 259C8EE8B1; Sun, 4 Mar 2007 09:58:47 -0300 (BRST) Received: from strongwill.g2ctech ([127.0.0.1]) by localhost (strongwill.g2ctech [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 22589-02; Sun, 4 Mar 2007 09:58:46 -0300 (BRST) Received: from jupiter.g2ctech (unknown [10.0.0.5]) by strongwill.g2ctech (Postfix) with ESMTP id 4307E8CE37; Sun, 4 Mar 2007 09:58:46 -0300 (BRST) Received: by jupiter.g2ctech (Postfix, from userid 1000) id E23E963A60; Sun, 4 Mar 2007 09:58:47 -0300 (BRT) From: Jorge Godoy To: Garry Saddington Cc: pgsql-general@postgresql.org Subject: Re: date format In-Reply-To: <200703041247.05097.garry@schoolteachers.co.uk> (Garry Saddington's message of "Sun\, 4 Mar 2007 12\:47\:05 +0000") References: <200703041247.05097.garry@schoolteachers.co.uk> Date: Sun, 04 Mar 2007 09:58:46 -0300 Message-ID: <87hct1412x.fsf@gmail.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: amavisd-new at g2ctech.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/190 X-Sequence-Number: 110380 Garry Saddington writes: > 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? ISO means y-m-d... -- Jorge Godoy