From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, dederer(at)spb(dot)cityline(dot)ru |
Subject: | Re: Bug with timestamp !!! |
Date: | 2001-05-13 04:53:12 |
Message-ID: | 20010513005311.A505@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs pgsql-general |
Sorry, that last post was a slip of the finger.
What I meant to say was:
I followed the same steps below on 7.1.0 (Linux),
and got this:
create_date
------------------------
2001-04-01 03:29:52-04
(1 row)
(i.e. 1 hour off)
I'm not using any strange locale settings or multibyte
stuff.
Weird...
Cheers,
Neil
On Sun, May 13, 2001 at 12:09:25AM -0400, Neil Conway wrote:
> On Sat, May 12, 2001 at 02:23:30PM +0400, Alexander Dederer wrote:
> > 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 | Mitch Vincent | 2001-05-13 05:00:23 | Re: Bug with timestamp !!! |
Previous Message | Neil Conway | 2001-05-13 04:09:25 | Re: Bug with timestamp !!! |
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2001-05-13 05:00:23 | Re: Bug with timestamp !!! |
Previous Message | Tom Lane | 2001-05-13 04:22:49 | Re: Postgres bug (working with iserverd) |
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2001-05-13 04:55:26 | FTP Problems -- maybe? |
Previous Message | Neil Conway | 2001-05-13 04:09:25 | Re: Bug with timestamp !!! |