Skip to Content

Format Time in Report

Nov 09, 2017 at 12:23 PM


avatar image


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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers