From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Date format |
Date: | 2000-01-14 16:19:17 |
Message-ID: | 20000114161917.I19251@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Someone posted a message here asking how you set the date style. We went
through
- environment variable PGDATESTYLE
- SET DateStyle TO
- the -e flag to the backend
but of course if you are using ISO it isn't necessary!! There is no
ambiguity in
test=> create table tab (t datetime);
CREATE
test=> insert into tab values('2000-1-2');
INSERT 416553 1
test=> select * from tab;
t
------------------------------
Sun 02 Jan 00:00:00 2000 GMT
(1 row)
The -e exists because there would be ambiguity between European/US, but with
year first, it must be yyyy-mm-dd (at least for sufficiently large years).
Sorry I can't remember your email address.
Cheers,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-01-14 16:43:37 | Re: Oids vs Serial fields (was Re: [GENERAL] searching oid's) |
Previous Message | Rick Delaney | 2000-01-14 16:10:05 | Oids vs Serial fields (was Re: [GENERAL] searching oid's) |