08-26-2013 12:37 PM
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.
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.
08-27-2013 07:11 AM
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)