Re: Millennium

> > There were problems with your BC dates -- they were a whole year out! > Informix believes in year 0 (sort of), and the calendrical system doesn't. > Of course, you may have some problems getting any 1st Century AD date into > the system (1..99 AD) as Informix is apt to 1900 to such dates:-) Actually, > as long as you use 3 or 4 digits for the year, you are OK. How do you get > BC dates -- I can't get it to allow dates BC? > > Yours, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> > Hmmm, wonder how I did get it to work. Doesn't now. I distinctly remember getting it to work once upon a time. I even put in 1/1/0034 and then tried an SQL 'set dtfld = dtfld - 100 UNITS YEAR' - no joy. There I go shooting off at the mouth again before checking myself. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ What's the difference between a duck? _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________