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

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 (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-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

pgsql-admin by date

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

pgsql-bugs by date

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

pgsql-general by date

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

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