Home / server / Questions / 99038
Accepted
sergiogx
Asked: 2010-01-04 12:33:15 +0800 CST

informix stores date with a 2 digit year instead of 4, how do I correct this?

  • 772

How do I make informix handle 4 digit years?

I have both windows and suse servers using informix

Thank you.

sql

1 Answers

  1. Best Answer

    The values of DBDATE and DBCENTURY affect the number of digits in the year.

    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.

    See also GL_DATE and DBTIME.

    Edit:

    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.

    • 4