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 ?

Mario

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 |////////  /|

|                      +-----------------------------------+////  / ///|
| 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.|//  / /////|

+----------------------+-----------------------------------+-----------+

: 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".

: 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!

June

----   June Tong                              Informix Software    ----
----   Senior Consultant                      (415) 926-6140       ----

----       Location-du-jour: on vacation in Mountain View, CA      ----
*
* Standard disclaimers apply
*
- Please do not send me requests/questions by mail.  When I have the knowledge
- and time permits, I try to answer questions on comp.databases.informix, but
- travel schedule, time, and volume make responding to personal requests
- difficult and often slow.  Please call your local Informix Technical Support
- organization for assistance with technical issues.

 > : 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.
 >

 > : 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
 >

+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA       http://www.informix.com |////////  /|

|                      +-----------------------------------+////  / ///|
| 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.|//  / /////|

+----------------------+-----------------------------------+-----------+