Horton
Menu

Re: date_part bug

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: salva@ronincoders.com
Cc: pgsql-bugs@postgresql.org
Date: 2001-03-30T01:20:43Z
Lists: pgsql-bugs 
> 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 upcoming 7.1 release.

                      - Thomas