Thanks! That did it:
tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth;
dayofmonth
31
(1 row)
tbs=# SET TIMEZONE = 'GMT' ;
SET VARIABLE
tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth;
dayofmonth
1
(1 r
> 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
> I'm using postgres 7.0.2. When I use date_part('day', date) sometimes I
> get wrong values. Ie:
> and date_part('day', '1999-3-28')=27
> and date_part('day', '2000-3-26')=25
> Is it a bug?
It is a problem evaluating day numbers around daylight savings time
transitions. Fixed (I believe) in the
