Skip site navigation (1) Skip section navigation (2)

Re: Part 1 of several - Converting a varchar to an interval

From: Shawn <postgres(at)xmtservices(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Part 1 of several - Converting a varchar to an interval
Date: 2008-03-26 16:27:25
Message-ID: 200803261627.26055.postgres@xmtservices.net (view raw or flat)
Thread:
Lists: pgsql-sql
On Wednesday 26 March 2008 16:16:57 you wrote:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
>    ?column?
> --------------
>  00:02:14.987
> (1 row)


Thanks Adrian!  

Wow!  

Shawn

pgsql-sql by date

Next:From: Adrian KlaverDate: 2008-03-26 16:32:34
Subject: FW: Re: Part 1 of several - Converting a varchar to an interval
Previous:From: ShawnDate: 2008-03-26 16:21:55
Subject: Re: Export Access 97 to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group