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
=======================*/

Reply via email to