With 7.1beta, I get: day | day ------------+----- 2000-04-02 | 2 2000-04-01 | 1 2000-04-03 | 3(3 rows)
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
-- Bruce Momjian | http://candle.pha.pa.us 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