| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: domains aren't subtypes, right?
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=leandroReceived on Sun Jun 08 2003 - 16:26:52 CDT
![]() |
![]() |