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

timestamp (minor bug)

From: "And(dot) Andruikhanov" <andy(at)euinf(dot)dp(dot)ua>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: timestamp (minor bug)
Date: 2001-07-22 11:20:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
  Good day.

  System Configuration
    Architecture: Intel Pentium
    Operating System: FreeBSD 4.2-STABLE
    PostgreSQL version:   PostgreSQL-7.1.2
    Compiler used:  gcc 2.95.2

  Description of problem

Wrong result in timestamp value between "winter" and "summer" time:

select '2001-03-24 03:00'::timestamp;
 2001-03-24 03:00:00+02
(1 row)

It's OK, but another example will demonstrate error:
select '2001-03-25 03:00'::timestamp;
 2035-05-22 09:58:04+03
(1 row)

NOTICE:  DateStyle is ISO with European conventions

  Best regards..

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-07-22 15:51:05
Subject: Re: timestamp (minor bug)
Previous:From: Tatsuo IshiiDate: 2001-07-22 11:10:32
Subject: Re: libpgtcl doesn't use UTF encoding of TCL

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