Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: domains aren't subtypes, right?

Re: domains aren't subtypes, right?

From: Leandro Guimarães Faria Corsetti Dutra <lgcdutra_at_terra.com.br>
Date: Sun, 08 Jun 2003 23:26:52 +0200
Message-ID: <pan.2003.06.08.21.26.49.852786@terra.com.br>


On Wed, 04 Jun 2003 09:58:35 -0700, Mikito Harakiri wrote:

> 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

        Simple answer: why stored types have to be the same as represented ones?

-- 
 _
/ \  Leandro Guimarães Faria Corsetti Dutra     +41 (21) 648 11 34
\ /  http://br.geocities.com./lgcdutra/         +41 (78) 778 11 34
/ \  Responda à lista, não a mim diretamente!   +55 (11) 5686 2219
Rate this post if helpful: http://svcs.affero.net/rm.php?r=leandro
Received on Sun Jun 08 2003 - 16:26:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US