Re: domains aren't subtypes, right?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Wed, 4 Jun 2003 09:58:35 -0700
Message-ID: <LFpDa.4$W71.119@news.oracle.com>

"Paul G. Brown" <paul_geoffrey_brown_at_yahoo.com> wrote in message news:57da7b56.0306031727.209ae842_at_posting.google.com...
> Well, now we're into a philosphical discussion entirely off-topic to
> c.d.t. (But I share your sense of taste in this instance . . . .)

OK, closer to the topic.

Proposition. The only date type allowed stored in the RDBMS should be INSTANCE/TIMESTAMP Other datatypes are functions:

DATE = FLOOR(TIMESTAMP / Day)
TIME = TIMESTAMP (mod) Day

Storing timestamp in inferior units is possible, but just a handicap to the system evolution and progress. Besides, what is the TIME: instant, interval, or just a number in a fancy base system? Received on Wed Jun 04 2003 - 11:58:35 CDT