Re: French date

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.

--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux