Was generating a report for the the jobs that was executing in a workflow.
I was running this query to get the start and end time from the database.
select oh_name as JOB_NAME,ah.ah_timestamp1 ActivationDateTime ,
ah.ah_timestamp2 StartDateTime,ah.ah_timestamp4 EndDateTime
from ah, oh where oh_idnr = ah_oh_idnr and oh_otype in ('JOBS')
and ah_timestamp1 >= '2016-12-13' and OH_Name='JOBS.RENAME_FILES_HOST'
The output that was generated was as below
JOB_NAME ActivationDateTime StartDateTime EndDateTime
JOBS.RENAME_FILES_HOST 2016-12-13 08:31:50.000 2016-12-13 08:32:16.000 2016-12-13 08:32:17.000
But when I checked in the statistics window for that particular job, it was different
JOBS.RENAME_FILES_HOST 12/13/2016 3:31:50 12/13/2016 3:32:16 12/13/2016 3:32:17
We have EST time zone, but in the database it was not showing correctly.
In database its showing +5 hrs added to the actual EST time when it was run.
Has any one faced such a kind of issue.
Thanks and Regards,