cancel
Showing results for 
Search instead for 
Did you mean: 

Configure Timezone to UTC for DB

lsharman
Champ in-the-making
Champ in-the-making

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 happen?

Thanks

3 REPLIES 3

chenshaoyi
Champ in-the-making
Champ in-the-making

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

lsharman
Champ in-the-making
Champ in-the-making

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

serverTimezone=UTC

chenshaoyi
Champ in-the-making
Champ in-the-making

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