topic Re: Configure Timezone to UTC for DB in Alfresco Forum

Configure Timezone to UTC for DB

lsharman — Mon, 23 Oct 2017 17:11:35 GMT

I'm using Activiti configured with a MySQL database. Currently, all timestamps in the Activiti tables (i.e, process and task start_time_ and end_time_) are stored using the local timezone. I need these dates to be stored in UTC. Is there a configuration parameter that I can set to cause this to ha

Re: Configure Timezone to UTC for DB

chenshaoyi — Fri, 22 Feb 2019 08:54:58 GMT

Do you still have the problem? I have the problem too.

Re: Configure Timezone to UTC for DB

lsharman — Fri, 22 Feb 2019 12:37:40 GMT

The MySQL JDC connection string in your properties file needs to be modified to specify the time zone. I added the following:

serverTimezone=UTC

Re: Configure Timezone to UTC for DB

chenshaoyi — Mon, 25 Feb 2019 03:09:01 GMT

I add the parameter in my app.yml, but it does not work. The user task create time is still the server local time.