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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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