I believe that you can set desired timezone using oracle.sessionTimeZone property, e.g.:
sqoop import -Doracle.sessionTimeZone=America/Los_Angeles --connect ... Is this what you're looking for? Jarcec On Mon, Oct 07, 2013 at 09:41:11PM +0000, Vikash Talanki -X (vtalanki - INFOSYS LIMITED at Cisco) wrote: > Hi , > > I am trying to import a table that has a date field in oracle. > After Importing , I see that for some dates there is a mismatch of time by 1 > hr. > I think this effect is due to day light saving. > > When I import the same table using Oraoop, I am getting the correct field > data. > Please let me know if there is any way around to achieve the same result in > sqoop as Oraoop. > > Regards > ----------------------- > Vikash T > +1 (408)506 2024 >
signature.asc
Description: Digital signature
