Received: from hotmail.com (law-f309.hotmail.com [209.185.131.13]) by hub.org (8.9.3/8.9.3) with SMTP id DAA53699 for ; Wed, 5 Jan 2000 03:38:16 -0500 (EST) (envelope-from oomoomi@hotmail.com) Received: (qmail 37013 invoked by uid 0); 5 Jan 2000 08:37:42 -0000 Message-ID: <20000105083742.37012.qmail@hotmail.com> Received: from 195.200.226.110 by www.hotmail.com with HTTP; Wed, 05 Jan 2000 00:37:42 PST X-Originating-IP: [195.200.226.110] From: "omid omoomi" To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] datetime fields have '60' in seconds field Date: Wed, 05 Jan 2000 00:37:42 PST Mime-Version: 1.0 Content-Type: text/plain; format=flowed Hi, I've just done the same case on my computer, seems that every thing is OK! : ( using freebsd 3.2 , pg 6.5.2 ) isp=> create table test( f1 text , f2 datetime); CREATE isp=> insert into test values('aaa','1999-12-31 12:05:40'); INSERT 51099 1 isp=> insert into test values('bbb','1999-12-31 12:05:00'); INSERT 51100 1 isp=> select * from test ; f1 |f2 ---+---------------------------- aaa|Fri Dec 31 12:05:40 1999 IRT bbb|Fri Dec 31 12:05:00 1999 IRT (2 rows) -------------------- regards. omid omoomi >From: Werner Fraga >Reply-To: werner.fraga@computalog.com >To: pgsql-sql@postgreSQL.org >Subject: [SQL] datetime fields have '60' in seconds field >Date: Fri, 31 Dec 1999 13:18:18 -0700 > >When a DATETIME field is modified and the seconds are set to zero, the >field >always shows 60 seconds instead: > >testdb=> create table datetab (dt datetime); >CREATE >testdb=> insert into datetab (dt) values ('1999-12-31 12:05:00'); >INSERT 27361 1 >testdb=> select * from datetab; >dt >-------------------------- >31/12/1999 12:05:60.00 MST >(1 row) > >I am using Linux Mandrake 6.1, Postgres 6.5.1-7mdk, glibc 2.1.1-16mdk, >kernel >2.2.13-7mdk > > >************ > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com