DATE ISSUE WHILE LOADING

sam334 · Post by **sam334** » 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.

chulett · Post by **chulett** » Mon Nov 10, 2014 11:40 am

More information, please. What is your source? What is your target? What data type do these columns come in as? Go out as? What transformations if any are done? Otherwise we're just guessing.

sam334 · Post by **sam334** » Wed Nov 12, 2014 12:23 pm

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.