Forums  »  adTempus  »  General  »  executionHistoryItem DateStart DateFinish Daylight Savings Time

executionHistoryItem DateStart DateFinish Daylight Savings Time

Ken T (33 posts)
November 3, 2020 05:20 PM
Accepted Answer

Hi Bill,

I had a chance to query the executionHistoryItem table and noticed the time recorded in the DateStart and DateFinish columns didn't reflect the updated Daylight Savings Time change. The time didn't reflect 1 hour back.

Do I have to update my adTempus version? We might be running 4.6. I have to check.

Permalink
Bill Staff (604 posts)
November 4, 2020 08:11 AM
Accepted Answer
The ExecutionStart and ExecutionFinish timestamps are always in UTC. For each column there is a corresponding column (ExecutionStartTZ and ExecutionFinishTZ) that shows the offset (in minutes) from UTC for the value. So to get the real ExecutionStart, you need to add ExecutionStartTZ minutes to ExecutionStart.
Permalink
Ken T (33 posts)
November 4, 2020 09:30 AM
Accepted Answer

Thanks Bill!

I had some pre-written code that I simply ran. I calculated DateStart by subtracting 7 hours from ExecutionStart. And similarly did the same for ExecutionFinish. I didn't realize that I was using a calculation.

Thanks for the clarification!

Ken

Permalink

Replies are disabled for this topic.