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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aklaver(at)comcast(dot)net (Adrian Klaver)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Date: 2008-03-26 17:14:28
Message-ID: 29426.1206551668@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

aklaver(at)comcast(dot)net (Adrian Klaver) writes:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
> ?column?
> --------------
> 00:02:14.987
> (1 row)

Or even easier:

regression=# select 134987 * interval '1 msec';
?column?
--------------
00:02:14.987
(1 row)

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2008-03-26 17:21:32 Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Previous Message Shawn 2008-03-26 16:34:22 Re: Question 2 Interval and timestamptz