Postgres Pro
Downloads
Home   >   mailing lists

Re: DATESTYLE setting - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: DATESTYLE setting
Date
Msg-id Pine.LNX.4.44.0304081624490.1127-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to DATESTYLE setting  (Erwin Ambrosch <naus.office@aon.at>)
Responses Re: DATESTYLE setting  (Erwin Ambrosch <naus.office@aon.at>)
List pgsql-admin
Tree view 
> 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

pgsql-admin by date:

Previous
From: Erwin Ambrosch
Date:
Subject: DATESTYLE setting
Next
From: Erwin Ambrosch
Date:
Subject: Re: DATESTYLE setting