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
-----------------------------------------------------------------
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? |