Re: Set Datestyle doesn't appear to be working

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Jeff Self <jself(at)nngov(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Set Datestyle doesn't appear to be working
Date: 2002-11-06 21:06:09
Message-ID: 1036616770.14768.2069.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2002-11-06 at 19:25, Jeff Self wrote:
> I'm running PostgreSQL 7.2.1 on a Debian Linux server. I have added the
> line: PGDATESTYLE=ISO,US to postmaster.conf and restarted PostgreSQL but
> any fields with the Date type still show up as '2002-11-06'. I want them
> to show up as '11-06-2002'.

ISO format means "yyyy-mm-dd"; you are getting exactly what you asked
for. The ",US" part of your spec is controlling how dates are
interpreted on input, so it is not useless, but to get what you want you
must specify "POSTGRES,US".

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Let all that you do be done in love."
1 Corinthians 16:14

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2002-11-06 21:07:49 Re: Set Datestyle doesn't appear to be working
Previous Message Bruce Momjian 2002-11-06 19:45:41 Re: Set Datestyle doesn't appear to be working