Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Tool_Tip
Creator III
Creator III

QMC tast status time zone is UTC different than local time

Dear all,

We have noticed that all other timezone in QMC is matching with our local time except the task status as shown below. Task status time is showing 03:59:47 UTC however it should show 03:59:47+4 UTC.

Note: We have already checked server time and also with service account log in the server time is showing correct as per local time

Tool_Tip_0-1733891684130.png

 

Labels (1)
1 Reply
Chanty4u
MVP
MVP

Try this sql query 

SELECT

    task_name,

    start_time AT TIME ZONE 'UTC' AT TIME ZONE 'Your/LocalTimezone' AS local_start_time,

    end_time AT TIME ZONE 'UTC' AT TIME ZONE 'Your/LocalTimezone' AS local_end_time

FROM public.task_execution_l

ogs;