AnsweredAssumed Answered

Difference time in the UI statistics and the database for a particular job

Question asked by avinash_k09 on Dec 13, 2016
Latest reply on Dec 14, 2016 by avinash_k09

Hi,

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,

Avinash

 

Outcomes