DATE ISSUE WHILE LOADING
Posted: Mon Nov 10, 2014 10:32 am
All,
Need a help in DATE issue in server job.
We have two columns which are creating the issue due to day light saving.
Call_Attend Call_Ended
2014-11-05 11.55PM 2014-11-05 11.59PM
So, these two input columns should have the same date. Now for time change some of the records inserted as,
Call_Attend Call_Ended
2014-11-05 11.58PM 2014-11-06 12.00AM
Our target Call_Entered column is directly mapped with Call_Ended in Input source.
Any help how to fix the issue. Due to this some calls are going to next day (11/06) instead of (11/05)
Appreciate your help as always..
Thanks.
Need a help in DATE issue in server job.
We have two columns which are creating the issue due to day light saving.
Call_Attend Call_Ended
2014-11-05 11.55PM 2014-11-05 11.59PM
So, these two input columns should have the same date. Now for time change some of the records inserted as,
Call_Attend Call_Ended
2014-11-05 11.58PM 2014-11-06 12.00AM
Our target Call_Entered column is directly mapped with Call_Ended in Input source.
Any help how to fix the issue. Due to this some calls are going to next day (11/06) instead of (11/05)
Appreciate your help as always..
Thanks.