date_part bug
Started by Salva Maineabout 25 years ago2 messagesbugs
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�
Re: date_part bug
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