Received: from computalog.com ([209.82.103.230]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA79690 for ; Tue, 4 Jan 2000 09:48:41 -0500 (EST) (envelope-from werner.fraga@computalog.com) Received: from tserver.edmonton.computalog.com (mug.computalog.com [209.82.103.229]) by computalog.com (8.8.7/8.8.7) with ESMTP id IAA27690 for ; Tue, 4 Jan 2000 08:00:24 -0700 Received: from shorty.edmonton.computalog.com (wfraga@shorty [10.89.4.26]) by tserver.edmonton.computalog.com (8.8.7/8.8.7) with SMTP id HAA11125 for ; Tue, 4 Jan 2000 07:48:43 -0700 From: Werner Fraga Reply-To: werner.fraga@computalog.com Organization: Computalog Ltd. To: pgsql-sql@postgresql.org Subject: datetime fields have '60' in seconds field Date: Fri, 31 Dec 1999 13:18:18 -0700 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <99123115004704.02807@shorty.edmonton.computalog.com> Content-Transfer-Encoding: 8bit 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