Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e73FKuG66551 for ; Thu, 3 Aug 2000 11:20:58 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id LAA08148; Thu, 3 Aug 2000 11:20:44 -0400 (EDT) To: poange@technologist.com cc: Karel Zak , pgsql-sql@postgresql.org Subject: Re: a question about dates and timestamp In-reply-to: <00080311565801.00710@ange.alpinfo.fr> References: <00080311565801.00710@ange.alpinfo.fr> Comments: In-reply-to Ange Michel POZZO message dated "Thu, 03 Aug 2000 11:30:31 +0200" Date: Thu, 03 Aug 2000 11:20:44 -0400 Message-ID: <8145.965316044@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/24 Ange Michel POZZO writes: > select datetime(abstime( floor (value) )); > select datetime(abstime( int4 (value) )); > select datetime(abstime( numeric_int4 (value) )); > in all case : > ERROR: pg_atoi: error in "952969611.000000": can't parse ".000000" That was fixed in January. Update to 7.0 and it'll work fine. You might be able to make it work in 6.5 like this: abstime(int4(float8(numeric))) regards, tom lane