Re: French date

]Jean-Michel Chabanne wrote:
> evon600c wrote:
> > Hello,
> > Is there a simple way to configure the postgres server so that it always
> > understand the french date format 'dd/mm/yyyy' ?
> > Or is there a call i can perform in my client application that could
> > have the same effect ?
> >
> > I wish i had not to set some easy forgetable environment variables such
> > as LC_TIME.
> >
> > For instance in SQL Server i was able to issue a "set dateformat 'dmy'"
> > in the begining of all my transactions to get it done and that was fine
> > for me (and my customers...)
> >
> > Many thank's in advance.
>
> Wen connected you may do SET DateStyle = 'SQL,European';
>
> Or, with pgsql, before the connection you may export the variable
> PGDATESTYLE='SQL,European'
>
> This should work fine, but I have noticed that it does not work on one
> of my DB and I don't know why.

You can use set datestyle in postgresql.conf in 7.3.X.  In 7.2, it had
to be an environment variable before the postmaster started, or us SET
as a command.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073