Horton

Bug with timestamp !!!

Alexander Dederer <dederer@spb.cityline.ru>

View thread View on postgr.es
From: Alexander Dederer <dederer@spb.cityline.ru>
To: pgsql-admin@postgresql.org.pgsql-bugs@postgresql.org.pgsql-general@postgresql.org
Date: 2001-05-12T10:23:30Z
Lists: 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