Value of Date type column is getting decremented with two day on sqooping the data from SQL server to Hive

[#1]

I have one table in database where insertdate is of 'Date' type. However when I import the table into hive using sqoop values in hive tables are getting decremneted.

Example. RDBMS --> insertdate='2013-04-01'

Hive --> insertdate='2013-03-30'

I have used below command to import data:

sqoop import --connect 'jdbc:sqlserver://localhost;username=XXXXX;password=XXXXXXX;database=XXXXXXXXXX'--table tbl_name \ --warehouse-dir /user/hive/warehouse --m 1 \ --hive-import --hive-database db_name --hive-overwrite --null-string '\\N' --null-non-string '\\N' --hive-drop-import-delims

[#2]

You need to review timezone settings on sql server and on your cluster, you might have discrepancy with GMT vs local timezone.

[#3]

I have cheked timestamp on cluster as well as on SQL server ,both are in IST timezone.Is there any other possibility?