Re: Date problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Date problem
Date
Msg-id 8261.1043703473@sss.pgh.pa.us
Whole thread Raw
In response to Re: Date problem  ("Ricardo Ryoiti S. Junior" <suga@netbsd.com.br>)
List pgsql-general
"Ricardo Ryoiti S. Junior" <suga@netbsd.com.br> writes:
> On Mon, 27 Jan 2003, Marcelo Pereira wrote:
>> How can I make PostgreSQL to use dates as DD/MM/YYYY ????

>     I use "SET DATESTYLE TO SQL,EUROPEAN" as soon as the connection is
> made.

In 7.3 you can set that as the default datestyle in postgresql.conf.
There are klugier ways of making it the default in prior releases
(PGDATESTYLE env. variable or -e postmaster switch, if memory serves).

            regards, tom lane

pgsql-general by date:

Previous
From: "Luke Pascoe"
Date:
Subject: Re: Inherited tables and NOT NULL (pg 7.2.1)
Next
From: Medi Montaseri
Date:
Subject: Re: When to Vacuum