Re: Bug with timestamp !!!
От | Mitch Vincent |
---|---|
Тема | Re: Bug with timestamp !!! |
Дата | |
Msg-id | 004b01c0db69$9dfee2b0$0200000a@windows обсуждение исходный текст |
Ответ на | Bug with timestamp !!! (Alexander Dederer <dederer@spb.cityline.ru>) |
Ответы |
Re: Re: Bug with timestamp !!!
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: