Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How many bytes does a DATE use?

552527Oct 1 2007 — edited Oct 1 2007
Having trouble finding this in the 10g documentation. How many bytes does a date data type use?
thanks.

Comments

APC 
SQL> select vsize(sysdate) from dual
  2  /
VSIZE(SYSDATE)
--------------
             7

Cheers, APC

Blog : http://radiofreetooting.blogspot.com/

511365

Please see below:

SQL> create table ztest (dt date);
 
Table created
 
SQL> 
SQL> select data_length from user_tab_columns
  2  where table_name = 'ZTEST';
 
DATA_LENGTH
-----------
          7
Nicolas Gasparotto
Take a look to the online documentation linked below :
Oracle® Database SQL Reference
10g Release 2 (10.2)
Part Number B14200-02
Oracle Built-in Datatypes
expecially code datatype 12.

Valid date range from January 1, 4712 BC to December 31, 9999 AD. The default format is determined explicitly by the NLS_DATE_FORMAT parameter or implicitly by the NLS_TERRITORY parameter. The size is fixed at 7 bytes. This datatype contains the datetime fields YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND. It does not have fractional seconds or a time zone.

Nicolas.
600809
char(10)=10 bytes
date=7 bytes
number(10,2)=((10-2)/2+1)=5 bytes
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 29 2007
Added on Oct 1 2007
#general-database-discussions
4 comments
3,647 views