Re: [HACKERS] Date/time types: big changeu

> 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);
CREATE
test=> insert into x values ('02/01/99');
INSERT 18697 1
test=> select * from x;
y
------------
02-01-1999
(1 row)

test=> set datestyle to 'iso';
SET VARIABLE
test=> select * from x;
y
------------
1999-02-01
(1 row)

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