Thread

1. date_part bug

   Salva Maine <salvamaine@yahoo.com> — 2001-03-28T10:50:46Z

   Hello:
   
   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?
   
   -- 
   Salvador Mainé
   
   

2. Re: date_part bug

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2001-03-30T01:20:43Z

   > 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