Horton

Re: Data type conversion

Jeff Boes <jboes@nexcerpt.com>

View thread View on postgr.es
From: Jeff Boes <jboes@nexcerpt.com>
To: pgsql-sql@postgresql.org
Date: 2003-10-03T16:20:59Z
Lists: pgsql-sql 
Jan Pips wrote:
> How to convert the interval type into integer, float or any "countable" data
> type at the time of table creation using
> select ... into?
> 

I'm guessing you want something like this:

SELECT EXTRACT('EPOCH' FROM INTERVAL
     '1 days 4 hours 15 minutes 23 seconds');


-- 
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
            ...Nexcerpt... Extend your Expertise