How to Convert "Interval" --> Integer?

Posted in 1994

Ken Miles — Wed, 24 Aug 1994 21:10:23 GMT — source: Informix-list mailing list archive (1991-1998)

Is there a way in Online 5.0 SQL or in Stored Procedures to take a column that is of type "interval second(7) to second" and convert it to an integer? We have tables with some columns of type interval and want to display their values in various data access tools none of which understand what an Informix "Interval" data type is. Ideally, I'd like to convert it in a view definition but there doesn't appear to be any such thing as: select . . . int(table.interval column) . . . that we can find documented. -Ken Miles kenm@vcd.hp.com