Date and time formats

When the IBM® 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 IBM 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, IBM 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.

Display formats can include names of eras (as in the Japanese Imperial date system) and non-Gregorian calendars (such as the Arabic lunar calendar).

For example, the Taiwan culture uses the Ming Guo year format in addition to the Gregorian calendar year. For dates before 1912, Ming Guo years are negative. The Ming Guo year 0000 is undefined; any attempt to use it generates an error. The following table shows some era-based dates.
Gregorian year Ming Guo year Remarks
1993 82 1993 – 1911 = 82
1912 01 1912 – 1911 = 01
1911 –01 1911 – 1912 = –01
1910 –02 1910 – 1912 = –02
1900 –12 1900 – 1912 = –12
Japanese Imperial-era dates are tied to the reign of the Japanese emperors. The following table shows Julian and Japanese era dates. It shows the Japanese era format in full, with abstract multibyte characters for the Japanese characters, and in an abbreviated form that uses romanized characters (gengo). The abbreviated form of the era uses the first letter of the English name for the Japanese era. For example, H represents the Heisei era.
Gregorian date Abstract Japanese era (in full) Japanese era (gengo)
1868/09/08 A1A2B1B201/09/08 M01/09/08
1912/07/30 A1A2B1B245/07/30 M45/07/30
1912/07/31 A1A2B1B201/07/31 T01/07/31
1926/12/25 A1A2B1B215/12/25 T15/12/25
1926/12/26 A1A2B1B201/12/26 S01/12/26
1989/01/07 A1A2B1B264/01/07 S64/01/07
1989/01/08 A1A2B1B201/01/08 H01/01/08
1995/01/01 A1A2B1B207/01/01 H07/01/01

Here A1A2 and B1B2 represent multibyte Japanese characters. For more information, see Customize date and time display formats.