Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
GLS User's GuideThe Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in Informix® products.
GLS fundamentalsThe Global Language Support (GLS) feature lets Informix® products handle different languages, cultural conventions, and code sets for Asian, African, European, Latin American, and Middle Eastern countries.
A GLS localeIn a client/server environment, both the database server and the client application must know which language the data is in to be able to process the application data correctly.
Display formatsThe display format (sometimes referred to as an end-user format) is the format in which data is displayed, and it differs from the internal format that is used to store the data in the database.
Date and time formatsWhen the HCL Informix® product reads a string that contains time data, it uses the display format to determine how to convert this string to the internal integer value for a DATETIME column.

Date and time formats

When the HCL Informix® product reads a string that contains time data, it uses the display format to determine how to convert this string to the internal integer value for a DATETIME column.

When the HCL Informix product prints a string that contains time data, it uses the time display format to determine how to format the internal integer value for a DATETIME column as a string. In the same way, HCL Informix products use the date display format to read and print strings for the internal values of the date data types.

Important: Display formats specify how client applications view data, but do not affect the internal format of DATETIME or DATE values stored in the database.

The display formats for date and time can include the names and abbreviations for days of the week and months of the year, and the commonly used representations for dates, time (12-hour and 24-hour), and DATETIME values.

For more information, see Customize date and time display formats.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.