I think you probably have to resort to query import with TO_CHAR(COL,'DD-MON-YY')
Venkat On Fri, Aug 29, 2014 at 1:16 PM, Venkat, Ankam <[email protected]> wrote: > Thanks Venkat. > > This works but not getting the date in the required format. > > DATE field at source is 23-Aug-04. It is imported as 2004-08-23. > > Any resolution for this? I want to import it as 23-Aug-04. > > Regards, > Venkat > > -----Original Message----- > From: Venkat Ranganathan [mailto:[email protected]] > Sent: Friday, August 29, 2014 9:59 AM > To: [email protected] > Subject: Re: Import from Oracle - Date is converted as Timestamp > > You need to specify a connection parameter file (see --connection-param-file > option) > > The contents should read > oracle.jdbc.mapDateToTimestamp=false > > Venkat > > On Fri, Aug 29, 2014 at 8:36 AM, Venkat, Ankam <[email protected]> > wrote: >> Sqoop is converting DATE fields Timestamp. I think it’s a JDBC problem. >> >> >> >> I tried using the option -D mapDateToTimestamp=false. But, it was not >> useful. >> >> >> >> My DATE format on Oracle is dd-MMM-yy and data is imported in the form >> of yyyy-MM-dd hh:mm:ss.n >> >> >> >> Any workaround for this? >> >> >> >> Regards, >> >> Venkat Ankam >> >> > > -- > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity to > which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader of > this message is not the intended recipient, you are hereby notified that any > printing, copying, dissemination, distribution, disclosure or forwarding of > this communication is strictly prohibited. If you have received this > communication in error, please contact the sender immediately and delete it > from your system. Thank You. -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
