Configure Timezone to UTC for DB

cancel
Showing results for 
Search instead for 
Did you mean: 
lsharman
Member II

Configure Timezone to UTC for DB

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
chenshaoyi
Member II

Re: Configure Timezone to UTC for DB

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

lsharman
Member II

Re: Configure Timezone to UTC for DB

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
Member II

Re: Configure Timezone to UTC for DB

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