Q: Convert INTERVAL to FLOAT

Posted in 1997

Ian Bishrey — 27 May 1997 13:14:39 GMT — source: Informix-list mailing list archive (1991-1998)

On: Informix SE 7.1 Openlink 2.6B MS-Query 2.0 MS-Excel 7.0 Hi, Is there an easy way of converting an INTERVAL (e.g. difference between two DATETIMES) into a regular numeric data type? I want to take an expression like: EXTEND(DateTime1 - DateTime2, HOUR TO MINUTE) and copy it into an INTEGER field (say) where 1 INTEGER unit = 1 minute Any ideas? TIA Ian