Skip to Content

Format Time in Report


I created a Report for all Jobs with several Status from one application.

SELECT DISTINCT jd.Name, j.Status, j.ScheduledStartTime FROM Job j, JobDefinition jd, JobDefinitionType jdt, Application a WHERE j.JobDefinition=jd.UniqueId AND jd.ParentApplication=a.UniqueId AND a.Name='R2P' AND jd.JobDefinitionType=jdt.UniqueId AND jdt.Name NOT LIKE 'JobChain' AND j.Status IN ('E','H','Q','K','A','T') ORDER BY j.ScheduledStartTime

I use timezone GMT and so the column ScheduledStartTime is shown with this timezone.

The report is for colleagues in China and I want to show the time-column in timezone Asia/Chongqing. How can I format the column?

Best regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers