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