Postgresql 7.0 bug

From: root <root(at)esc(dot)rosemere(dot)qc(dot)ca>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Postgresql 7.0 bug
Date: 2000-04-29 18:13:01
Message-ID: Pine.LNX.4.10.10004291412040.1108-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Eric Prevost-Dansereau
Your email address : eric(at)esc(dot)rosemere(dot)qc(dot)ca

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium II

Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.13 ELF

PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0

Compiler used (example: gcc 2.8.0) : gcc 2.91.66

Please enter a FULL description of your problem:
------------------------------------------------

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) ?

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp;

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

I don't have any idea

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message claud yu 2000-05-01 00:49:42 7.0 bug ??
Previous Message Tom Lane 2000-04-29 14:47:59 Re: creating temp table...