Re: datestyle

Martín Marqués writes:

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

No, the European option only applies if you select the "SQL" or "Postgres"
date style.  There is no such thing as "European ISO".

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter