Postgres Pro
Downloads
Home   >   mailing lists

Re: Part 1 of several - Converting a varchar to an interval - Mailing list pgsql-sql

From Shawn
Subject Re: Part 1 of several - Converting a varchar to an interval
Date
Msg-id 200803261627.26055.postgres@xmtservices.net
Whole thread Raw
In response to Part 1 of several - Converting a varchar to an interval  (Shawn <postgres@xmtservices.net>)
List pgsql-sql
Tree view 
On Wednesday 26 March 2008 16:16:57 you wrote:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
>    ?column?
> --------------
>  00:02:14.987
> (1 row)


Thanks Adrian!

Wow!

Shawn

pgsql-sql by date:

Previous
From: Shawn
Date:
Subject: Re: Export Access 97 to PostgreSQL
Next
From: aklaver@comcast.net (Adrian Klaver)
Date:
Subject: FW: Re: Part 1 of several - Converting a varchar to an interval