How do I make informix handle 4 digit years?
I have both windows and suse servers using informix
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
DBDATE defaults to MDY4/ (for the US English locale) which includes a four-digit year.
DBCENTURY controls how to interpret data that includes two-digit years.
A DATE type stores an integer number of days since December 31, 1899 in four bytes which will handle dates for 2^31 days which is over 5.8 million years into the future.
A DATETIME type can store anything from milliseconds to years in a size that's appropriate to the precision.
See Chronological Data Types which says, in part:
To customize this DATETIME format, choose your locale appropriately or set the GL_DATETIME or DBTIME environment variable. For more information about these environment variables, see the IBM Informix: GLS User's Guide.