When we enter a date into a form with a 2 digit year (eg 1/1/96) Informix adds “1900” to it nicely for me. Will it add “2000” at the turn of the century?
The bad news: No, current versions will not. You’ll have to change all your screens to accept 4 digit years and check to make sure sensible values have been entered. You might want to add a CHECK constraint to your date columns: CHECK (YEAR(datecol) >= 1950) The good news: If your code is based on a product using the (as yet unreleased) 7.20 ESQL/C, or some later version, will you get the more flexible behaviour given by the DBCENTURY environment variable, which is documented below. At the moment, there are no plans to back-port this to any of the version 4, 5 or 6 products.
Related Questions
- When we enter a date into a form with a 2 digit year (eg 1/1/96) Informix adds "1900" to it nicely for me. Will it add "2000" at the turn of the century?
- What do I need to enter in Year 10 % and Year 12 % under Educational Details in the form for candidates testing outside India?
- How many students enter the contest each year?
