DATE Data Type - Oracle to SQL Server Migration

In Oracle, DATE data type stores date and time data (year, month, day, hour, minute and second).

A DATE value requires 7 bytes in Oracle:

The first byte stores the first 2 digits of the year (century) plus 100 . The second byte stores the last 2 digits of the year plus 100.

The third and fourth bytes store the month and day, respectively.

The fifth, sixth and seventh bytes store hour, minute and second, but all these values are incremented by 1.

For example, the DATE value '2012-09-17 13:31:01' is internally stored as:

Oracle OCI returns the DATE data in the internal 7-byte format if you bind the column (OCIDefineByPos i.e.) using SQLT_DAT data type code.

• Oracle to SQL Server Migration Knowledge Base

SQLines offers database administration, optimization and migration services for Oracle and SQL Server databases and applications. For more information, please Contact Us.