On Fri, Oct 03, 2003 at 09:23:46 +0200,
Jan Pips <jan_pips(at)op(dot)pl> wrote:
> How to convert the interval type into integer, float or any "countable" data
> type at the time of table creation using
> select ... into?
You can use extract to do that. See the date/time function documentation.
Note that months get treated as 30 days when extracting periods less
than a month from an interval.