> Short Description
> DATE_PART() BUG? We have an SQL statement that is giving wrong output.
> tbs=# SELECT version();
> -------------------------------------------------------------
> PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96
> Here is a simple example:
> SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth
> ----------
> 31
> Why does April 1st display as May 31st?
This is a known "feature" of 7.0.x (and earlier) on daylight savings
time boundaries. You will see the problem go away if you set your time
zone to GMT. Upgrade to 7.1.x.
- Thomas