Hi Cheolsoo, Thanks for the inputs. AFAIK, SQL Developer also uses JDBC but its dumping the data in the same format as its in DB. So, i am wondering why Sqoop is unable to dump the data similar to SQL Developer? I am using SQL Developer 3.1.07.
Thanks, Anil Gupta On Mon, Mar 12, 2012 at 2:08 PM, Cheolsoo Park <cheol...@cloudera.com>wrote: > 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 >> > > -- Thanks & Regards, Anil Gupta
