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?
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.
> Vikash T
> +1 (408)506 2024