Re: Millennium

Posted in 1995

Richard Thomas — 14 Nov 1995 11:03:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Peter, This was discussed at some length a while back. Basically there is no magic wand that Informix or anyone else can wave - if your dates are in DMY2/ format, 01/01/01 will ALWAYS mean 1st January, 1901. Any decent database manager should now create databases using DMY4/ (UK) or MDY4/ = (US) dates. Thus 1st January, 2001 will be represented by 01/01/2001. (Kerry, maybe this should go in the FAQ?) Cheers, Richard. ----------------------------------------------------------------- =20 | _ =AF\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | ----------------------------------------------------------------- =20 > Does anyone know how gracefully Informix ISQL functions will handle > dates at the ens of the millennium? Has Informix made any = announcement? >=20 > Peter Jennings. >=20