Re: [Help] : Oracle Date Field (vs. SQL Server)

Steve Miller wrote:
>
> Dates are important to us so we track a number of them. When we look
> at our data storage estimates we arrive at 60 G for SQL Server and 120
> G for Oracle. This is attributable to the difference in the date
> field lengths. For SQL it's 4 bytes (SmallDate) and for Oracle it's
> 49 bytes! Although Oracle uses its own internal format to store 7
> bytes each for day, month, century, year, hour, minute and second,
> we're only interested in century, yr, mth.
>

The Oracle date format uses 7 bytes for the entire date, not 7 bytes for each component.

-- 
Roger Harris
Oracle DBA
GE Credit Corp
Danbury, CT