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.
DATE ISSUE WHILE LOADING
Moderators: chulett, rschirm, roy
Craig,
Sorry for the late reply. I found the issue and solved it. The problem was, the input is in DB2 and datetime is in GMT. So, when any phone call comes in after 12.AM, it was taking the next day instead of current day. But technically it is current day not next day. I used an IF function in transformer and it is cool now.
Thanks.
Sorry for the late reply. I found the issue and solved it. The problem was, the input is in DB2 and datetime is in GMT. So, when any phone call comes in after 12.AM, it was taking the next day instead of current day. But technically it is current day not next day. I used an IF function in transformer and it is cool now.
Thanks.