datestyle - Mailing list pgsql-general

From Martín Marqués
Subject datestyle
Date
Msg-id 01060410001605.19567@bugs
Whole thread Raw
Responses Re: datestyle  (will trillich <will@serensoft.com>)
Re: datestyle  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Hi, I'm trying to set the datesyle in postgres to european (day before
month). I'm starting postgres with pg_ctl with these options:

pg_ctl -o "-i -o -e" -D /usr/local/pgsql/data/ start

But when I select a date field I get this:

pruebas=> select * from pr_fecha;
   fecha    |  horas
------------+----------
 2001-12-25 |
 2001-12-25 |
            | 16:00:00
 2001-03-13 |
(4 rows)

pruebas=>

Shouldn't the date field be 25/12/2001?

Saludos... :-)

--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: RE: editing postgresql.conf for network access
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL security concerns