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: 20010722135456.I98532-100000@www.euinf.net (view raw or flat)
Thread:
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;
        ?column?
------------------------
 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;
        ?column?
------------------------
 2035-05-22 09:58:04+03
(1 row)

NOTICE:  DateStyle is ISO with European conventions
LC_ALL=ru_RU.KOI8-R


  Best regards..
 --


In response to

Responses

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-2014 The PostgreSQL Global Development Group