Re: DBCENTURY

June Tong wrote: > > Mark D. Stock (mdstock@informix.com) wrote: > : 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. > > I think you meant to say "Present". Whoops! Sorry. :-) R Present. The year is expanded with the present century. > : 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 > > Please note that these examples were done around November 1995 (sort > of a > critical piece of information). These are not the values you would > get today! Tee hee! ;-) -- 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"!|/ ////////| +----------------------+-----------------------------------+-----------+