Re: How many bytes to store DATE info in Oracle?

From: <nasof_at_hotmail.com>
Date: Wed, 16 Sep 1998 12:56:01 GMT
Message-ID: <6toch1$r1s$1@nnrp1.dejanews.com>

I believe I've read in the Oracle8 DBA Handbood (Oracle Press) that is 7 bytes. Also if you run the following on a date field (also works on other fields) you can find the size:

SELECT distinct VSIZE(col1)
FROM TAB1; You should get:

VSIZE(col1)

Hope this helps...
Frank

In article <35ff3f99.107055377_at_newshost.interact.net.au>, granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:
> Hi all,
>
> I've looked the manuals, but the info on datatypes doesn't seem to
> cover it. How many bytes of storage are used for a DATE field?
>
> Ciao
> Fuzzy
> :-)
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 16 1998 - 07:56:01 CDT