Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group