From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | Ian Harding <iharding(at)pakrat(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Re: date/time |
Date: | 2001-01-18 15:53:28 |
Message-ID: | 20010118155328.K29761@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Tue, Jan 16, 2001 at 07:24:15PM -0800, Ian Harding wrote:
> snef wrote:
>
> > Hi,
> > I have read the man's with Postgres.
> > But I can't seem to get Postgres use European time notation (dd/mm/yyyy).
> >
> > Where can I adjust this? (in which file?)
> >
> > Snef
>
> Actually, I think you may want the environment variable PGDATESTYLE. It
> sets the datestyle for new connections. That is all I know about it!
Either set the environment variable PGDATESTYLE to 'Postgres,European' or
send the query
set datestyle='Postgres,European'
(I think SQL instead of Postgres works too)
eg:
quartz% printenv PGDATESTYLE
Postgres,European
rfb=# show datestyle;
NOTICE: DateStyle is Postgres with European conventions
SHOW VARIABLE
Cheers,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | mike | 2001-01-18 16:20:40 | 7.1 initdb error |
Previous Message | Richie Duggan | 2001-01-18 11:50:37 | Pictures again |
From | Date | Subject | |
---|---|---|---|
Next Message | Gordan Bobic | 2001-01-18 16:01:05 | Tuning queries and distinct behaviour |
Previous Message | Zeugswetter Andreas SB | 2001-01-18 15:24:10 | AW: [HACKERS] compilation error |