On Wed, 22 Jan 2003, David H. Lynch Jr. wrote: > I have always had a particular affection for Dates as Julian day > numbers the number of days since xxxx. > > They are really easy to manipulate, compare, Virtually all the > nasty aspects of dates become a function of the routines for printing > them or inputting them, Ignoring issues of the differing calendars used > prior to the late 1700's you can represent most of recorded history in a > 3 byte integer. > > I have never understood why most databases tended to store dates > in any other format.
You're confusing phsyical with logical. A given DBMS may _store_ dates as julian days (or MJD, or whatever) and you'd never know, since you only deal with the representation of the date (as a Gregorian date). If you're suggesting that JD would be a good representation, I'd disagree. -dave /*======================= House Absolute Consulting www.houseabsolute.com =======================*/