Thread: Re: Data type conversion

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