Re: DATE TYPE SIZE?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 17 Nov 1999 08:06:08 -0500
Message-ID: <DagyOIoyluba2l6ntVOFd+NExzKb@4ax.com>

A copy of this was sent to peter <misybh_at_hmc.com.tw> (if that email address didn't require changing) On 17 Nov 1999 01:08:12 GMT, you wrote:

>Hi
> We all know that char(1) menas 1 byte .

actually it means 0, 1, 2 or 3 bytes.

> how many bytes of 'DATE' mean???
>

0, 1, or 7.

See the server concepts manual for information on how all datatypes are physically represented on disk.

> Thanks in advance.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Nov 17 1999 - 07:06:08 CST