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_at_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 - 18:58:35 CEST

This message: [ Message body ]
Next message: Otto Vask: "Re: How to express SQL3/OLAP analysis functions by ORACLE9iR2 DML ?"
Previous message: Jim Wolfe: "Re: DATABASE QUESTION ! ! ! ! ! !"
Maybe in reply to: Mikito Harakiri: "Re: domains aren't subtypes, right?"
In reply to Paul G. Brown: "Re: domains aren't subtypes, right?"
Next in thread: --CELKO--: "Re: What is this model technique called"
Reply: Jonathan Leffler: "Re: domains aren't subtypes, right?"
Reply: Leandro Guimarães Faria Corsetti Dutra: "Re: domains aren't subtypes, right?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message