| From: | "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron-office(dot)nl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: date/time |
| Date: | 2001-01-16 17:00:30 |
| Message-ID: | 20010116180030.B8328@cistron-office.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Mon, Jan 15, 2001 at 23:09:26 +0100, snef wrote:
> But I can't seem to get Postgres use European time notation (dd/mm/yyyy).
Do
SET DATESTYLE TO 'POSTGRES,EUROPEAN'
and use European time notation with hyphens, e.g.
SELECT * FROM Foo WHERE start >= '31-12-2000'
> Where can I adjust this? (in which file?)
On my system, it's /etc/postgresql/postmaster.init, the "PGDATESTYLE"
setting.
HTH,
Ray
--
LWN normally tries to avoid talking much about Microsoft - it is simply
irrelevant to the free software world most of the time.
http://www.lwn.net/2000/0406/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Xianfeng Liu | 2001-01-16 17:16:32 | How to back up a large object? |
| Previous Message | Niral Trivedi | 2001-01-16 16:01:20 | pg_shadow permission denied for pgAdmin!!! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorch | 2001-01-16 17:39:36 | Query question |
| Previous Message | Mike Miller | 2001-01-16 16:47:53 | INIT DB FAILURE |