|
robvolk
Most Valuable Yak
USA
15559 Posts |
 Posted - 12/05/2000 : 18:30:18
|
You could fake it, something like storing the year, day and month in separate fields, and then write a trigger to do some simple validation to ensure a correct date. You'd lose the ability to do DateDiff() and DateAdd(). You could try adding a differential to a regular date (say 4,000 years), since you can future date to Dec. 31, 9999, but it will probably mess up your date arithmetic, and you'll need to do some fancy calculations to display the date correctly.
Some problems, though: the Gregorian calendar, which we sort of use, was FUBARed in October 1582 and two weeks were removed, (don't know if you knew that or not), so your math would have to account for that too. There were other calendar anomalies during the time period you'd be recording (no leap year, etc.)
If you can use Oracle, it can handle ungodly date ranges (Jurassic, Cretaceous, Big Bang, you get the idea).
Edited by - robvolk on 12/05/2000 18:38:01 |
 |
|
how to store and manipulate Very Old dates ?
