datestyle

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: <pgsql-general(at)postgresql(dot)org>
Subject: datestyle
Date: 2001-06-04 07:00:16
Message-ID: 01060410001605.19567@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grumpa 2001-06-04 09:10:19 form generator?
Previous Message Tom Lane 2001-06-04 03:49:49 Re: Current value of a sequence?