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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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
  • Message-id: <29426.1206551668@sss.pgh.pa.us> <text/plain>
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
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group