Re: DATES MANAGEMENT ON C-ISAM 5.00

Posted in 1999

a_blonde@mindless.com — Fri, 19 Nov 1999 11:44:51 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > I'm here again with questions on dates!! > Now I've solved the problem with DBCENTURY (='C') and it > works! > > I have another problem with the fact that 2000 is a > bissextile year. Sounds kinky Dude! > infact if I run: > > select date("29/02/00") from podet > --> 1204: Invalid year in date > > select date("28/02/00") from podet > --> 28/02/2000 That's because CISAM does not support DBCENTURY, so the '00' is expanded to 1900, which is NOT a leap year Dude. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com