Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;