Re: Postgresql 7.0 bug

From: Karl DeBisschop <kdebisschop(at)h00a0cc3b7988(dot)ne(dot)mediaone(dot)net>
To: root <root(at)esc(dot)rosemere(dot)qc(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgresql 7.0 bug
Date: 2000-05-29 13:30:54
Message-ID: 3932710E.4A785C4B@h00a0cc3b7988.ne.mediaone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

root wrote:
>
> When I execute from psql:
> SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp;
>
> I get:
> ?column?
> ----------
> 23:00
> (1 row)
>
> Why april 2nd, 2000 don't last 1 day (or 24 hours) ?

Because April 2nd was the beginning of daylight savings time.

Karl DeBisschop
www.infoplease.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zacharie Ambroise 2000-05-29 14:02:14
Previous Message Tom Lane 2000-05-29 03:49:23 Re: Postgresql 7.0 bug