Hi Anil, Some of the Oracle JDBC drivers (version < 9.2 && > 11.1) auto-converts date to timestamp: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#08_01
Since Sqoop uses the JDBC driver to import data from the Oracle db, dates in output files are in the form of timestamp. Thanks, Cheolsoo On Mon, Mar 12, 2012 at 1:57 PM, anil gupta <anilgupt...@gmail.com> wrote: > Hi All, > > I am exporting a table from Oracle using Sqoop. I have a date column in > Oracle table with format as DD-MON-YY. I get the same format when i dump > the data from Oracle SQL Developer. But, when i dump the data using Sqoop i > get the following format YYYY-MM-DD HH:MM:SS.x. > For the value "24-JAN-08" in DB, Sqoop will dump it as "2008-01-24 > 00:00:00.0". Is this an expected behavior? If yes, please let me know why > does sqoop adds the unnecessary timestamp at the end and also modifies the > original date format? > > > -- > Thanks & Regards, > Anil Gupta >
