Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 26 Mar 2008 13:14:28 -0400
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
- Follow-Ups:
- References:
- FW: Re: Part 1 of several - Converting a varchar to an interval
- From: Adrian Klaver
- FW: Re: Part 1 of several - Converting a varchar to an interval
- Prev by Date: Re: Question 2 Interval and timestamptz
- Next by Date: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Previous by thread: FW: Re: Part 1 of several - Converting a varchar to an interval
- Next by thread: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Indexes: