From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: datestyle |
Date: | 2001-06-04 17:08:11 |
Message-ID: | Pine.LNX.4.30.0106041907220.768-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Barnard | 2001-06-04 17:59:14 | libpq and PostgreSQL NOTICEs |
Previous Message | Jan Wieck | 2001-06-04 16:53:59 | Re: template1, can there be a template2/3/4? |