Hi Anil, This issue is already being tracked by the following Apache JIRAs:
https://issues.apache.org/jira/browse/SQOOP-451 https://issues.apache.org/jira/browse/SQOOP-456 In fact, I am currently working on adding new options via which the user can specify format masks for date, time, and timestamp. Thanks, Cheolsoo On Mon, Mar 12, 2012 at 2:26 PM, anil gupta <anilg...@buffalo.edu> wrote: > From the link you had sent me in previous mail. Here is something which > might stop the date being converted into Timestamp: > "If for some reason your app is very sensitive to this change and you > simply must have the 9i-10g behavior, there is a connection property you > can set. Set mapDateToTimestamp to false and the driver will revert to > the default 9i-10g behavior and map DATE to Date. " Will this help in > resolving this problem? > > Thanks, > Anil > > On Mon, Mar 12, 2012 at 2:17 PM, anil gupta <anilg...@buffalo.edu> wrote: > >> 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 >> > > > > -- > Thanks & Regards, > Anil Gupta >
