You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "zhangguancheng (JIRA)" <ji...@apache.org> on 2013/03/07 04:24:12 UTC

[jira] [Created] (SQOOP-935) DATE columns in an Oracle database should be imported as a JDBC TIMESTAMP

zhangguancheng created SQOOP-935:
------------------------------------

             Summary: DATE columns in an Oracle database should be imported as a JDBC TIMESTAMP
                 Key: SQOOP-935
                 URL: https://issues.apache.org/jira/browse/SQOOP-935
             Project: Sqoop
          Issue Type: Bug
          Components: connectors/oracle
    Affects Versions: 1.4.2
            Reporter: zhangguancheng


If not, data of DATE import from orcale 9i-10g will be lack of time information. That's because the Oracle DATE SQL type contains both date and time information as does java.sql.Timestamp while 9i-10g drivers maps SQL DATE to JDBC DATE type which represents a date consisting of day, month, and year. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira