Is there a way to set the timezone to UTC within the DataSource config

Question

We have a Grails 2.1.0 project and our staging and production dbs are on shared db servers.

We would like to set the timezone to UTC (0) on a per connection basis, is there an easy way to do this from the DataSource.groovy file.

Other suggestions also welcome.

Have you checked http://stackoverflow.com/questions/7605953/how-to-change-mysql-timezone-in-java-connection ? — Tomo, Aug 25 '12 at 10:06

score 2 · Accepted Answer · edited May 23 '17 at 10:26

2

Jared's answer to grails/mysql timezone change suggests that we don't need to adjust the mysql timezone at all, as the datetime fields are stored as MySql DateTime. I solved this for my local machine by adding -Duser.timezone=UTC to $JAVA_OPTS, so this may be the required solution.

We've tried this across local and stage environments and this does solve the issue.

edited May 23 '17 at 10:26

Community

1
1

answered Sep 07 '12 at 07:23

chim

8,407
3
52
60

Is there a way to set the timezone to UTC within the DataSource config

1 Answers1