top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How does Oracle store the DATE datatype internally?

+1 vote
402 views
How does Oracle store the DATE datatype internally?
posted Feb 11, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Oracle stores data in a proprietary format. It uses 7 bytes for Data storage and 1 byte is used for the length data.
The following is the mapping of the oracle's date type
Byte 1 -> Century
Byte 2 -> Year
Byte 3 -> Month
Byte 4 -> Day
Byte 5 -> Hour
Byte 6 -> Minute
Byte 7 -> Second

answer Feb 12, 2015 by Arun Gowda
...