Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA24675 for ; Tue, 15 Jun 1999 09:41:33 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id JAA22559; Tue, 15 Jun 1999 09:39:57 -0400 (EDT) To: vikrant@chemquick.com cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Mail about typecast In-reply-to: Your message of Tue, 15 Jun 1999 11:17:08 +0800 <3765C5B3.C05DC56D@chemquick.com> Date: Tue, 15 Jun 1999 09:39:56 -0400 Message-ID: <22557.929453996@sss.pgh.pa.us> From: Tom Lane Vikrant Rathore writes: > select date_part('epoch','12 hours'::timespan)::float4; > ERROR: function dtof(float8) does not exist What Postgres version are you using? The above query appears to work fine in both 6.4.2 and 6.5. I'm guessing you are getting bit by some bug in an older release ... If you don't want to update, you might also try the variant forms select float4(date_part('epoch','12 hours'::timespan)); select date_part('epoch','12 hours'::timespan) AS float4; regards, tom lane