Re: Impossible Database Design?

"Marshall" <marshall.spight_at_gmail.com> wrote in message news:1147811975.609575.17310_at_j33g2000cwa.googlegroups.com...
> Bob Badour wrote:
> >
> > If one accepts the limitation of a finite representation, which in the
> > end one has no choice over, then there will always be a finite endpoint
> > at the extreme end of the representation. For a time representation,
> > that might be 999999/12/31 or some other large finite value.
>
> Trivia:
>
> The java Date class uses a 64 bit number, interpreted as
> miliseconds since Jan. 1, 1970, to capture time/date
> values. Amusingly, sometimes people get upset with this
> idea because, you know, time is "infinite." If I did the
> math correctly, the Date class can "only" represent dates
> until the year 292280995. Pointing that out usually quiets
> them down.
>
>

And you know, for sure, that around October 292280994, there's going to be one hell of a market for people to rework code! Received on Tue May 16 2006 - 22:51:45 CEST