| 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 | Resend email |
| 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
| 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 |
| 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) |
| 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 |