answersLogoWhite

0

from <http://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#i1847>

Overview of DATE Datatype

The DATE datatype stores point-in-time values (dates and times) in a table. The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds (after midnight).

Oracle can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 4712 CE (Common Era, or 'AD'). Unless BCE ('BC' in the format mask) is specifically used, CE date entries are the default.

Oracle uses its own internal format to store dates. Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day, hour, minute, and second.

The correct answer is 7 bytes for a date column.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How many bytes are used to store a 64-bit number?

how many bytes are there in a 64-bit machine? Another Answer: It takes 8 bytes to store a 64 bit number.


How many bytes are used to store a 64 bit number?

how many bytes are there in a 64-bit machine? Another Answer: It takes 8 bytes to store a 64 bit number.


What is collection in oracle 11g?

Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections 1.Associative array 2.Nested Table 3.Varray


What is 11g in oracle 11g?

Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections 1.Associative array 2.Nested Table 3.Varray


A byte stored in AL is present in array of 10 bytes stored in the memory Store the number of occurrences of the byte in register AH?

Of 10 bytes simply stored in the memory? YAWN...


How much data can be stored in a system that has a capacity of 232 bytes?

A system with a capacity of 232 bytes can store 4,294,967,296 bytes of data.


How many bytes of data can a 60 gb hard drive store?

61440 Mega Bytes(MB) that is 62914560 Kilo bytes(KB) that is 64424509440 BYTES....- Mayank


How much data store in oracle database?

Oracle has many versions like 9i, 10g, 11g, 12c .Oracle database can store infinte data unless you have put any restriction on it.


How many bytes are needed to store 32767?

32767 is the maximum value that can be stored in two bytes.


How man character's can 8 bytes store?

One byte is made up of 8 bits, and each bit can store 1 character. Therefore, 8 Bytes can store 64 Characters.


What is Oracle Spatial Databas Engine server?

Oracle Spatial is an option of the Oracle Database Enterprise Edition. Its core component is a new datatype called SDO_GEOMETRY that is used to store geometric figures (points, lines and polygons) defined by one or more coordinates. This allows you to create "spatial" tables, i.e. tables that contain any number of regular columns and one column of type SDO_GEOMETRY (or even multiple such columns). You can then query those tables using spatial predicates (like CONTAINS, TOUCHES, INSIDE, WITHIN_DISTANCE etc). Things like "get me the land parcels of a certain type that are on the path of this pipeline", or "get the list of customers that live within 10km of a store". Databases that use Oracle Spatial are commonly used by commercial or open source GIS tools to store and manage their spatial data. Advanced capabilities include the storage of raster data (imagery), network searches, geocoding, routing, topology etc.


How many bytes of data can 32 MB of RAM store?

A stick of 512 megabytes of RAM can hold about 512 megabytes of data. It cannot, however, store it for long because it is volatile and is not designed to store data.