Received: from ns.dsn.ro ([217.156.107.1]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KJida12301 for ; Wed, 20 Jun 2001 15:44:41 -0400 (EDT) (envelope-from george@dsn.ro) Received: from dsn.ro (bla.dsn.ro [217.156.107.11]) by ns.dsn.ro (8.10.2/8.10.2) with ESMTP id f5KJ8S303676; Wed, 20 Jun 2001 22:08:28 +0300 Message-ID: <3B30F81E.5BE56B25@dsn.ro> Date: Wed, 20 Jun 2001 22:23:11 +0300 From: George Moga Organization: Data Systems Srl X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: Alessandro Rossi , pgsql-sql@postgresql.org Subject: Re: set datestyle to European PROBLEM References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/315 X-Sequence-Number: 3602 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