Re: How "BETWEEN date1 AND date2" determines century

Posted in 1995

Spokey the Wheeler — Sun, 10 Sep 95 14:40:55 GMT — source: Informix-list mailing list archive (1991-1998)

In article <42tq1g$45v@news.wwa.com> john@miso.wwa.com "pinoy_ako" writes: > Hi, > As we all know, year 2000 is just 5 years away. So what Is it really? Time flies when you're having fun! :-) > 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 You've got to be kidding! > condition? (BETWEEN "06/12/1998" AND "06/12/2002") IMHO, I think you'ld be crazy to trust any vendor to handle the dates for you. I suspect that software released after 1/1/2000 will default a "20", and there's no way they'd handle the 98-02 issue. HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregende andersche kondom!