Bug with timestamp !!!

From: Alexander Dederer <dederer(at)spb(dot)cityline(dot)ru>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-bugs(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org
Subject: Bug with timestamp !!!
Date: 2001-05-12 10:23:30
Message-ID: 9dj2rq$1ij$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general

Look this:
create table tmp (create_date timestamp);

#insert into tmp values('2001-04-01 02:29:52');
INSERT 1021715 1

#select * from tmp;
create_data
------------------------
2035-05-29 01:33:36-05
(1 row)

! ! ! !
It's work on FreeBSD 4.2. PostgreSQL install from:
postgresql-7.1.1.tar.gz
postgresql-base-7.1.1.tar.gz
postgresql-opt-7.1.1.tar.gz

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bhuvaneswari 2001-05-12 12:41:38 Error in installing pg-access
Previous Message Peter Eisentraut 2001-05-11 22:15:26 Re: psql produces core dump

Browse pgsql-bugs by date

  From Date Subject
Next Message Erik Hofman 2001-05-12 12:17:49 Re: Irix build failes (PSQL 7.1.1)
Previous Message Thomas Lockhart 2001-05-12 04:01:09 Re: Irix build failes (PSQL 7.1.1)

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2001-05-12 13:01:49 Re: newbie sql question: select every day another quote
Previous Message Simon Crute 2001-05-12 10:23:10 case sensitivity