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