size of date datatype

[Iyappanekp]

Can any one please clear my doubt. What is the size of a date data type in Oracle?

[JChiappa]

Internally Oracle databases stores the DATE datatype in seven bytes.One byte for each of the century, year, month, day, hour, minute and second. You will find this documented in the Server Administrator's Guide, IIRC

[]s

Chiappa

[noor]

Hello,

You can use the "vsize" fonction to have the number of bytes in the internal representation of your field.

try this : select vsize(sysdate) from dual;

Hope this helps

[jmodic]

Originally posted by noor
Hello,

You can use the "vsize" fonction to have the number of bytes in the internal representation of your field.

try this : select vsize(sysdate) from dual;

Which will return you 8 instead of 7 (Oracle uses 7 bytes for storing dates)! We have just recently had two long threads about this isue in DBA forum...