Planning Job Console Shows Incorrect Time

We recently saw an issue after using LCM to move a Planning application from one environment to another, in which the Planning Job Console stopped showing the start and end times for the jobs in the local timezone, and instead began showing them in UTC. The issue was with the USER_PREFS table in the Planning repository database – the TIME_ZONE field was populated with ‘null’ instead of NULL. A simple SQL script was necessary to correct the issue:

UPDATE HSP_USER_PREFS
SET TIME_ZONE = NULL
WHERE TIME_ZONE = 'null';

Don't forget to commit the changes. After a restart of the Planning services in the environment, we were able to log in, see the Job Console and note the times were now being shown using the correct time zone.