Oracle DATE datatype storage.
From: Randy Fought <FOUGHTRL_at_CTRVAX.VANDERBILT.EDU>
Date: 1995/07/24
Message-ID: <3v0gi8$cv1_at_helios.vanderbilt.edu>#1/1
Date: 1995/07/24
Message-ID: <3v0gi8$cv1_at_helios.vanderbilt.edu>#1/1
Internally Oracle stores the DATE datatype in seven bytes. One byte for each of the century, year, month, day, hour, minute and second.
We don't care about the hour, minute and second and we have many dates to store. This seems quite wasteful to store this in seven bytes when it could be done in four. Is there a way to internally store the date in four bytes?
Randy Received on Mon Jul 24 1995 - 00:00:00 CEST