From: George Moga <george@dsn.ro>
To: Alessandro Rossi <alex@sunrise.radiostudiodelta.it>
To: pgsql-sql@postgresql.org
Subject: Re: set datestyle to European PROBLEM
Date: Wed, 20 Jun 2001 22:23:11 +0300
Message-ID: <3B30F81E.5BE56B25@dsn.ro> (raw)
References: <Pine.LNX.4.05.10106150951100.6628-100000@sunrise.radiostudiodelta.it>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: george@dsn.ro, alex@sunrise.radiostudiodelta.it
Subject: Re: set datestyle to European PROBLEM
In-Reply-To: <3B30F81E.5BE56B25@dsn.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox