Re: Bug with timestamp !!!

ipa=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.1.1 on i386-unknown-freebsd4.2, compiled by GCC 2.95.2
(1 row)
ipa=# create table tmp (create_date    timestamp);
CREATE
ipa=# insert into tmp values('2001-04-01 02:29:52');
INSERT 295890 1
ipa=# select * from tmp;
         create_date
------------------------------
 Tue May 29 02:34:00 2035 EDT
(1 row)

I have datestyle set to postgres -- is that why this happened?

-Mitch

----- Original Message -----
From: "Neil Conway" <nconway@klamath.dyndns.org>
To: <pgsql-general@postgresql.org>; <dederer@spb.cityline.ru>
Sent: Sunday, May 13, 2001 12:53 AM
Subject: Re: Bug with timestamp !!!


> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>