Re: Set Datestyle doesn't appear to be working

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.Elphick@lfix.co.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