From: | George Moga <george(at)dsn(dot)ro> |
---|---|
To: | Alessandro Rossi <alex(at)sunrise(dot)radiostudiodelta(dot)it>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: set datestyle to European PROBLEM |
Date: | 2001-06-20 19:23:11 |
Message-ID: | 3B30F81E.5BE56B25@dsn.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Alessandro Rossi wrote:
> I have the defaul installation of postgres 7.0.3 and on another machine
> 7.1.2 on redhat 7.1
>
> I cannont get the date in correct form:
.....
> Is this a bug ?
>
> I think i should get dd-mm-yyy date format and not yyyy-mm-dd
>
> Is postgres using ISO date format as default ?
I had the same problem ... but I solved ...
(I use PostgreSQL 7.1 on RH 7.1 installed from rpm):
In "/etc/rc.d/init.d/postgresql" I modify in "start" arm ... from:
su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
to
su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -o '-i -o -e' -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
and, after I connect my application to the database, the first command is:
SET DATESTYLE TO 'Postgres';
and work fine ...
> Thanks
> Alex
George Moga,
Data Systems Srl,
Slobozia, ROMANIA
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2001-06-20 19:35:38 | select by streak |
Previous Message | jeff | 2001-06-20 19:07:33 | constraints, |