Postgres Pro
Downloads
Home   >   mailing lists

Thread: DATESTYLE setting

DATESTYLE setting

From
Erwin Ambrosch
Date:
Hi,

I've run postgresql and the default datestyle is
"DateStyle is ISO with US (NonEuropean) conventions".
I would like to have the default datestyle to be
"DateStyle is ISO with European conventions".

Is it possible to set the datestyle for an already set up Database.
As I know I can set the datestyle on a per connection basis, but I
need the default datestyle to be changed.

Thanks in advance
Erwin

Re: DATESTYLE setting

From
"A.Bhuvaneswaran"
Date:
> I've run postgresql and the default datestyle is
> "DateStyle is ISO with US (NonEuropean) conventions".
> I would like to have the default datestyle to be
> "DateStyle is ISO with European conventions".

If 7.3, add the below line in postgresql.conf and restart postmaster,
datestyle = 'iso, european'

regards,
bhuvaneswaran

Re: DATESTYLE setting

From
Erwin Ambrosch
Date:
On Tuesday 08 April 2003 12:56, A.Bhuvaneswaran wrote:
> > I've run postgresql and the default datestyle is
> > "DateStyle is ISO with US (NonEuropean) conventions".
> > I would like to have the default datestyle to be
> > "DateStyle is ISO with European conventions".
>
> If 7.3, add the below line in postgresql.conf and restart
> postmaster, datestyle = 'iso, european'

Thaks for the quik answer. Do you also know a solution for 7.2 and
7.1?

>
> regards,
> bhuvaneswaran
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: Have you checked our
> extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

Re: DATESTYLE setting

From
Tom Lane
Date:
Erwin Ambrosch <naus.office@aon.at> writes:
> Thaks for the quik answer. Do you also know a solution for 7.2 and
> 7.1?

Set PGDATESTYLE environment variable for postmaster.

            regards, tom lane