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 that months get treated as 30 days when extracting periods less than a month from an interval. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
