informix
Informix DataBlade API Programmer's Manual
DataBlade API Function Descriptions

mi_string_to_date()

The mi_string_to_date() function converts a text (string) representation of a date value to its binary (internal) DATE representation.

Syntax

Usage

The mi_string_to_date() function converts the date string that date_string references to its internal DATE value. An internal DATE value is the format that the database server uses to store a date in a column of the database.

Important: The mi_string_to_date() function replaces the mi_date_to_binary() function for string-to-internal-DATE conversion in DataBlade API modules.

The mi_string_to_date() function accepts the date string in the date format of the current processing locale. For more information, see the Informix Guide to GLS Functionality.

Return Values

mi_date is the internal DATE representation that mi_string_to_date() has created.
NULL indicates that the function was not successful.

Related Topics

See the descriptions of the following functions: mi_date_to_string(), mi_string_to_datetime(), mi_string_to_decimal(), mi_string_to_interval(), and mi_string_to_money().

For more information on how to convert date strings to internal DATE format, see Converting Date Between Text and Binary.


Informix DataBlade API Programmer's Manual, Version 9.2
Copyright © 1999, Informix Software, Inc. All rights reserved