Horton

Re: DATE_PART() BUG? We have an SQL statement that is giving wrong output.

Thomas Lockhart <lockhart@fourpalms.org>

View thread View on postgr.es
From: Thomas Lockhart <lockhart@fourpalms.org>
To: pkelly@ets.net, pgsql-bugs@postgresql.org
Date: 2001-05-25T13:44:47Z
Lists: pgsql-bugs 
> 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