Re: [HACKERS] Date/time types: big changeu - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Date/time types: big changeu
Date
Msg-id 200002161855.NAA05756@candle.pha.pa.us
Whole thread Raw
In response to Date/time types: big change  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Responses Re: [HACKERS] Date/time types: big changeu  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> I've just committed changes to "reunify" the date/time types.
> "timestamp" and "interval" are now the two primary date/time types for
> users. Also, I've changed the default date style to "ISO" (not just in
> time for Y2K, but we'll be ready for "Y3K").
> 

I think we need a consensus on this.  I think this may be a problem for
some people.  Comments?
test=> create table x ( y date);CREATEtest=> insert into x values ('02/01/99');INSERT 18697 1test=> select * from x;
y      ------------ 02-01-1999(1 row)test=> set datestyle to 'iso';SET VARIABLEtest=> select * from x;     y
------------1999-02-01(1 row)
 


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Date/time types: big change
Next
From: Michael Meskes
Date:
Subject: Re: [HACKERS] parser changes