-------------- Original message ----------------------
From: Tom Lane <tgl@[EMAIL PROTECTED]
>
> aklaver@[EMAIL PROTECTED]
(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@[EMAIL PROTECTED]
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
