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 | 1
2000-04-01 | 1
2000-04-03 | 3
(3 rows)
Is this fixed in a newer version? Am I doing something wrong?
TIA,
Daryl Herzmann