RE: Year 2K Question

Keep in mind, the century only defaults like this if the DBCENTURY variable is not set AND the century value is not present at input time. If all of your dates are input WITH a century value, then DBCENTURY is a moot point. Also, once a century value has been determined (by direct input, by DBCENTURY, or by default), the database will ALWAYS have a century associated with a date -- in fact, you CANNOT store a date in the database WITHOUT a century value. For the application that I was recently working on, we decided to mandate direct input of century values, whether the data comes from a user or from a mainframe download. This way we don't have to be concerned whether DBCENTURY will "window" the century value correctly for all dates in the application. HTH ================================ Paul A. Mosser, Open Systems DBA Wells Fargo Bank Tempe, Arizona mosserp@wellsfargo.com ================================ > -----Original Message----- > From: Chris Harding [SMTP:adsor@hotmail.com] > Sent: Friday, May 08, 1998 5:37 AM > To: informix-list@iiug.org > Subject: Year 2K Question > > I have read the Year 2000 document from Informix and in this is says > that > 'If the DBCENTURY variable is not present, the Informix product will > default the century value to the current century, which it obtains > from the computer's system clock.' > > Is this true for all informix products? > Or is this statement only true for the informix products which support > the DBCENTURY, at the end of this document there is a table of which > products > support the DBCENTURY variable. The products I am using are not on this > list > and I am starting to think that the second is true. > > Could anyone please clear things up for me, thank you very much. > > > > Adam Sorati > adams@sgen.com.au >