Re: French date

On Tue, 2002-12-31 at 10:10, 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 ?

SET DATESTYLE TO 'ISO,EUROPEAN'

> I wish i had not to set some easy forgetable environment variables such
> as LC_TIME.

For release 7.3 you can add this line to postgresql.conf:

DATESTYLE = 'ISO,European'

In earlier releases, you could define the environment variable

export PGDATESTYLE=ISO,European

before starting the postmaster - you could include it in your startup
script.
--
Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
LFIX Limited