Re: [PORTS] Port Bug Report: Error with date_part when checking month - Mailing list pgsql-ports

>   PostgreSQL version : 6.3
> Problem Description:
> --------------------
> When using the date_part function it seems to be off by a day.
> It excludes the first of this month and includes the first of next
> month in the query.

postgres=> select date_part('month', '6-1-1999'::datetime);
date_part
---------
        6
(1 row)

It appears to be fixed in more recent versions (though I haven't
confirmed that I can reproduce your symptom on v6.3).

v6.4.2 is the current version, and has significant improvements in all
areas.

                   - Tom