From: | aklaver(at)comcast(dot)net (Adrian Klaver) |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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:30:29 |
Message-ID: | 032620081730.4863.47EA8835000C8D51000012FF22069997359D0A900E04050E@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
-------------- Original message ----------------------
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> 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
I just tried this and got the following which is also what I got when using 'millisecond'
Select 134987 * interval '1 msec';
ERROR: invalid input syntax for type interval: "1 msec"
SELECT version();
version
------------------------------------------------------------------------------------------------
PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
--
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Conlon, Joseph F SIK | 2008-03-26 17:55:44 | Bizarre sort order |
Previous Message | Adrian Klaver | 2008-03-26 17:21:32 | Re: FW: Re: Part 1 of several - Converting a varchar to an interval |