devxlogo

Convert Time for Numbers

Convert Time for Numbers

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.

devx-admin

Share the Post: