Re: DBCENTURY

Mario Vsn Hamme wrote: > > Hi, > > Could somebody tell me what 's the significance of the DBCENTURY values? > I know that they are "C","P" or "R", but what's the meaning ? P Past. The year is expanded with both the current and past centuries. The closest date PRIOR to today's date is chosen. F Future. The year is expanded with both the current and future centuries. The closest date AFTER today's date is chosen. C Closest. The year is expanded with the past, current and future centuries. The date closest to today's date is chosen. R Future. The year is expanded with the present century. Or something. The default for DBCENTURY is R. Some examples: DBCENTURY Date Date Date Setting Entered Entered Entered 03/25/01 12/01/95 10/13/95 ---------------------------------------------------------- P 03/25/1901 12/01/1895 10/13/1995 F 03/25/2001 12/01/1995 10/13/2095 C 03/25/2001 12/01/1995 10/13/1995 R 03/25/1901 12/01/1995 10/13/1995 Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+