Re: date_part bug

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: salva(at)ronincoders(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: date_part bug
Date: 2001-03-30 01:20:43
Message-ID: 3AC3DF6B.CAA98867@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message sasha 2001-03-30 05:37:49 PORTS : Windows 95/98/2000
Previous Message Joe Shevland 2001-03-29 22:05:48 RE: [JDBC] Possible large object bug?