Horton

BUG in date_part

Alexandru COSTIN <acostin@nospamrds.ro>

View thread
From: "Alexandru COSTIN" <acostin@NOSPAMrds.ro>
To: pgsql-bugs@postgresql.org
Date: 2000-10-06T07:03:07Z
Lists: pgsql-bugs 
    Hello,
    I've discovered a bug in the date_part function. It returns 25 when
doing select date_part('day','2000-03-26'::date);
    Anyway, this isn't happening if casting the date to timestamp
    select date_part('day','2000-03-26'::timestamp);

                Alexander