pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (3+ messages)  latest in thread

Message-ID: <3B30F81E.5BE56B25@dsn.ro>
Permalink:  ../3B30F81E.5BE56B25@dsn.ro/
Also on:    postgresql.org/message-id/3B30F81E.5BE56B25@dsn.ro

 · 

reply

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