Received: from computalog.com ([209.82.103.230]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA94766 for ; Fri, 31 Dec 1999 14:15:09 -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 MAA25027 for ; Fri, 31 Dec 1999 12:25:26 -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 MAA13241 for ; Fri, 31 Dec 1999 12:17: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 12:06:57 -0700 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <99123112191701.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