Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id D43EB2E0062
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 26 Mar 2008 13:27:55 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 97863-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 26 Mar 2008 13:27:29 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.xmtservices.net (unknown [66.224.65.210])
	by postgresql.org (Postfix) with SMTP id EC1D42E0060
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2008 13:27:28 -0300 (ADT)
Received: (qmail 2912 invoked from network); 26 Mar 2008 16:27:26 -0000
Received: from unknown (HELO vaio.xmtservices.net) (192.168.0.101)
	by errol.xmtservices.net with SMTP; 26 Mar 2008 16:27:26 -0000
From: Shawn <postgres@xmtservices.net>
To: pgsql-sql@postgresql.org
Subject: Re: Part 1 of several - Converting a varchar to an interval
Date: Wed, 26 Mar 2008 16:27:25 +0000
User-Agent: KMail/1.9.9
References: 
 <032620081616.25220.47EA76F90001F10A0000628422007358349D0A900E04050E@comcast.net>
In-Reply-To: 
 <032620081616.25220.47EA76F90001F10A0000628422007358349D0A900E04050E@comcast.net>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200803261627.26055.postgres@xmtservices.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/175
X-Sequence-Number: 30503

On Wednesday 26 March 2008 16:16:57 you wrote:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
> =A0 =A0?column?
> --------------
> =A000:02:14.987
> (1 row)


Thanks Adrian! =20

Wow! =20

Shawn