Date format

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

Browse pgsql-general by date

  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)