topic SAS DI to Oracle in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122077#M293758 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I am facing problem in converting SAS datasets to Oracle in SAS DI.<BR />The columns having DATETIME. format in SAS is getting converted into DATE datatype in Oracle and time component of the </P><P>column is not showing in Oracle.<BR />For example:<BR />20AUG13:14:33:22 is showing as 20-AUG-13 only in Oracle, but the time component is missing.<BR />Please help me and provide a solution in SAS DI.</P></BODY></HTML> Mon, 26 Aug 2013 16:37:25 GMT Kshitij 2013-08-26T16:37:25Z SAS DI to Oracle https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122077#M293758 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I am facing problem in converting SAS datasets to Oracle in SAS DI.<BR />The columns having DATETIME. format in SAS is getting converted into DATE datatype in Oracle and time component of the </P><P>column is not showing in Oracle.<BR />For example:<BR />20AUG13:14:33:22 is showing as 20-AUG-13 only in Oracle, but the time component is missing.<BR />Please help me and provide a solution in SAS DI.</P></BODY></HTML> Mon, 26 Aug 2013 16:37:25 GMT https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122077#M293758 Kshitij 2013-08-26T16:37:25Z Re: SAS DI to Oracle https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122078#M293759 <HTML><HEAD></HEAD><BODY><P>You may just need to change the format in Oracle.&nbsp; As far as recall, Oracle stores all dates as datetime values.</P><P></P><P>Richard</P></BODY></HTML> Tue, 27 Aug 2013 01:27:06 GMT https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122078#M293759 RichardinOz 2013-08-27T01:27:06Z Re: SAS DI to Oracle https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122079#M293760 <HTML><HEAD></HEAD><BODY><P><A href="http://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#i1847" title="http://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#i1847">Native Datatypes</A></P></BODY></HTML> Tue, 27 Aug 2013 10:28:46 GMT https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122079#M293760 LinusH 2013-08-27T10:28:46Z Re: SAS DI to Oracle https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122080#M293761 <HTML><HEAD></HEAD><BODY><P>Nothing to do with DI. It is a common tranlation issue. Richard LinusH mad the same references&nbsp; </P><P><A href="http://support.sas.com/documentation/cdl/en/acreldb/66690/HTML/default/viewer.htm#p06jk0u30uhuj5n18fqw9sxr25lk.htm" title="http://support.sas.com/documentation/cdl/en/acreldb/66690/HTML/default/viewer.htm#p06jk0u30uhuj5n18fqw9sxr25lk.htm">SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Second Edition</A> (Data Types for Oracle)</P></BODY></HTML> Tue, 27 Aug 2013 11:11:19 GMT https://communities.sas.com/t5/SAS-Programming/SAS-DI-to-Oracle/m-p/122080#M293761 jakarman 2013-08-27T11:11:19Z