HI,I am running postgres version 7.0 and I do this...
akrherz=# create table test (day date);
CREATE
akrherz=# insert into test values('2000_04_02');
INSERT 13166281 1
akrherz=# insert into test values('2000_04_01');
INSERT 13166282 1
akrherz=# insert into test values('2000_04_03');
INSERT 13166283 1
akrherz=# select day, date_part('day', day) AS day from test; day | day
------------+-----2000-04-02 | 12000-04-01 | 12000-04-03 | 3
(3 rows)
Is this fixed in a newer version? Am I doing something wrong?
TIA,Daryl Herzmann