SAS DI to Oracle - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

SAS DI to Oracle

Posted 08-26-2013 12:37 PM (982 views)

Hi,
I am facing problem in converting SAS datasets to Oracle in SAS DI.
The columns having DATETIME. format in SAS is getting converted into DATE datatype in Oracle and time component of the

column is not showing in Oracle.
For example:
20AUG13:14:33:22 is showing as 20-AUG-13 only in Oracle, but the time component is missing.
Please help me and provide a solution in SAS DI.

3 REPLIES 3

Quartz | Level 8

Quartz | Level 8

Re: SAS DI to Oracle

Posted 08-26-2013 09:27 PM (913 views) | In reply to Kshitij

You may just need to change the format in Oracle. As far as recall, Oracle stores all dates as datetime values.

Richard

Tourmaline | Level 20

Tourmaline | Level 20

Re: SAS DI to Oracle

Posted 08-27-2013 06:28 AM (913 views) | In reply to Kshitij

Native Datatypes

Data never sleeps

Barite | Level 11

Barite | Level 11

Re: SAS DI to Oracle

Posted 08-27-2013 07:11 AM (913 views) | In reply to Kshitij

Nothing to do with DI. It is a common tranlation issue. Richard LinusH mad the same references

SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Second Edition (Data Types for Oracle)

---->-- ja karman --<-----

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!