Re: Impossible Database Design?
From: Marshall <marshall.spight_at_gmail.com>
Date: 16 May 2006 13:39:35 -0700
Message-ID: <1147811975.609575.17310_at_j33g2000cwa.googlegroups.com>
> 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.
Date: 16 May 2006 13:39:35 -0700
Message-ID: <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.
Marshall Received on Tue May 16 2006 - 22:39:35 CEST