On Fri, Oct 03, 2003 at 09:23:46 +0200,
Jan Pips <[EMAIL PROTECTED]> 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
How to convert the interval type into integer, float or any "countable" data
type at the time of table creation using
select ... into?
Pips
---(end of broadcast)---
TIP 8: explain analyze is your friend
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
