Oninit cdi / Archive
Talk to an expert →

Current century not being picked up

Posted in 2000

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues, Versions, Editions & End-of-Life

deeky@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hi all, We are running IDS 7.24-UC5.8 of IDS and 6.04 UC2 of 4GL and SQL. We are also running AIX 4.3.3.1 which has passed the IBM "fixcheck" Y@K test fine. Our problem is when we enter a 2 digit date "00" it is converted to "1900". I know using 4 digit dates is the answer, but unfortunatly the third party application allows for the entry of 2-digit dates. From what I have readon DBCENTURY I will need to upgrade SQL and 4GL to 7.2X in order to use DBCENTURY functionality. However, I was lead to believe that the current versions of these products are supposed to use the current cenrtury for year expansion as a default. This does not explain why if my system date is correct and my O/S is Y2K, how come "00" converts to "1900"? Any thoughts on my situation? TIA Derrick Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary