Question:
Does Informix have a function that converts datetime chars for numbers?
Answer:
Datetime is stored internally as an integer that represents the number of seconds from a certain starting date. The INTERVAL data type stores between two datetime values, while the EXTEND function pulls out various parts of a datetime value.