Dates appear offset by certain number of hours/mins

If your date columns appear to not reflect the accurate date/time expected and you are using a private agent then your timezone setting may not be set to the same value as your user timezone (PST, for example).

To correct this issue, you have the option to change your private agent timezone to PST by adding the following Java param to your run.sh (or run.bat if you are using windows:

-Duser.timezone=US/Pacific

so your JVM_ARGS line in your run.sh should look something similar to this:

JVM_ARGS="-Duser.timezone=US/Pacific -Xms128m -Xmx2024m -XX:PermSize=64m ........"

Once this is done, then restart your Agent.