How "BETWEEN date1 AND date2" determines century

Posted in 1995

pinoy_ako — 9 Sep 1995 23:37:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, As we all know, year 2000 is just 5 years away. So what will happen to current data entry screens which only accept dates formatted as "mm/dd/yy"? Right now, the 4gl(?) adds "19" before the yy. If you enter "123195", the final format will be "12/31/95" Also, how will the database handle the query below if the query is run in a day after year 2000? SELECT .... WHERE col1 BETWEEN "06/12/98" AND "06/12/02" Is the database intelligent(?) enough to know that 98 above is 1998 and 02 is 2002? Or do I have to make it a full year condition? (BETWEEN "06/12/1998" AND "06/12/2002") Pls. email or post. Thanks! John -- - J -