Informix DataBlade API Programmer's Manual DataBlade API Function Descriptions

The mi_interval_to_string() function creates an ANSI SQL standards text (string) representation of an interval value from its binary (internal) INTERVAL representation.

mi_string *mi_interval_to_string(intvl_data)

mi_interval *intvl_data;

intvl_data

is a pointer to the internal INTERVAL representation of the interval value.

Valid in Client LIBMI Application?	Valid in User-Defined Routine?
Yes	Yes

The mi_interval_to_string() function converts the internal INTERVAL value that intvl_data references into an interval string. The interval string has the following ANSI SQL standards format:

"YYYY-MM-DD HH:mm:SS.FFFFF"

 



YYYY

is the 4-digit year.


MM

is the 2-digit month.


DD

is the 2-digit day.


mm

is the 2-digit minute.


SS

is the 2-digit second.


FFFFF

is the fraction of a second, where the number if digits is specified by the date and/or time qualifier with a maximum precision of 5 digits.

If the internal INTERVAL value contains only a subset of this range, mi_interval_to_string() creates an interval string with the appropriate portion of the preceding format. For example, suppose intvl_data references the internal format of the interval 6 days, 5 hours, and 45 minutes. The mi_interval_to_string() function returns an mi_string value with the following interval string:

"06 05:45"

The mi_interval_to_string() function does not format the interval string in the date and time formats of the current processing locale.

See the descriptions of the following functions: mi_date_to_string(), mi_decimal_to_string(), mi_datetime_to_string(), mi_money_to_string(), and mi_string_to_interval().

For more information on how to convert internal INTERVAL format to interval strings, see Converting Date or Time Between Text and Binary.