Hi,
When I run the staged data, the date columns are showing wrong time. All the date columns should show 12:00 AM(midnight) because I am not storing time in the database.
For example:
Date: 08/11/2016 is showing as 11-aug-2016 12:00:00 AM
(my observation: Date is in Daylight saving - could be wrong )
Date: 11/10/2016 is showing as 09-Nov-2016 11:00:00 PM
(my observation: Date is not in Daylight saving - could be wrong )
I have checked OS timezone and java timezone and all are in synch. Is there any server level settings that should be checked to fix?
Thanks,
Surya