Configure MySQL to use UTC

CREATE TABLE test_utc (
  id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
  dateTimeAsString varchar(255) NOT NULL,
  dateTimeSample datetime NOT NULL,
  timestampSample timestamp NOT NULL
);

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

import org.junit.Test;

public class DateTimeUTCTest {

  @Test
  public void testDateTimeUTC() throws SQLException {
    final Calendar cal = getStartTime();
    final DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm zzz");

    /*
     * Clear the table of previous rows.
     */
    try (final Connection conn = getConnection()) {
      try (final PreparedStatement deleteStatement = conn.prepareStatement(
          "DELETE FROM test_utc")) {
        deleteStatement.execute();
      }

      /*
       * Insert the 4 dates 
       *  2014-11-02 00:30 CDT 
       *  2014-11-02 01:30 CDT 
       *  2014-11-02 01:30 CST 
       *  2014-11-02 02:30 CST 
       */
      final String insertPrefix = "INSERT INTO test_utc (dateTimeAsString, dateTimeSample, timestampSample) VALUES ";
      try (final PreparedStatement insertStatement = conn
          .prepareStatement(insertPrefix + "(?,?,?)")) {
        for (int i = 0; i < 4; ++i) {
          insertDateTime(insertStatement, cal, df);
          cal.add(Calendar.HOUR_OF_DAY, 1);
        }
      }
      
      /*
       * Insert the current timestamp using now().
       */
      try (final PreparedStatement insertStatement = conn
          .prepareStatement(insertPrefix + "(?,now(),now())")) {
        final String nowStr = df.format(new Date());
        insertStatement.setString(1, "now() - " + nowStr);
        insertStatement.execute();
      }
      
      /*
       * Insert the current timestamp using utc_timestamp().
       */
      try (final PreparedStatement insertStatement = conn
          .prepareStatement(insertPrefix
              + "(?,utc_timestamp(),utc_timestamp())")) {
        final String nowStr = df.format(new Date());
        insertStatement.setString(1, "utc_timestamp() - " + nowStr);
        insertStatement.execute();
      }
      
      /*
       * Read the rows inserted in the database and print out the results.
       */
      final String selectQuery = "SELECT * FROM test_utc order by id";
      try (final PreparedStatement readStatement = conn.prepareStatement(selectQuery);
          final ResultSet rs = readStatement.executeQuery()) {
        System.out.println("id\toriginalString\t\tdateTimeSample\t\ttimestampSample");
        while (rs.next()) {
          int index = 1;
          final int id = rs.getInt(index++);
          final String dateTimeAsString = rs.getString(index++);
          final Timestamp dateTimeSample = rs.getTimestamp(index++);
          final Timestamp timestampSample = rs.getTimestamp(index++);
          final String formattedDateTime = df.format(dateTimeSample);
          final String formattedTimestamp = df.format(timestampSample);
          System.out.println(id + "\t" + 
              dateTimeAsString + "\t" + 
              formattedDateTime + "\t" + 
              formattedTimestamp);
        }
      }
    }
  }

  /**
   * @return November 2, 2014 00:30:00, which is 30 minutes before DST ends.
   */
  private Calendar getStartTime() {
    final Calendar cal = Calendar.getInstance();
    cal.set(Calendar.MONTH, Calendar.NOVEMBER);
    cal.set(Calendar.DAY_OF_MONTH, 2);
    cal.set(Calendar.YEAR, 2014);
    cal.set(Calendar.HOUR_OF_DAY, 0);
    cal.set(Calendar.MINUTE, 30);
    cal.set(Calendar.SECOND, 0);
    cal.set(Calendar.MILLISECOND, 0);
    return cal;
  }

  /**
   * @return JDBC  connection to the database
   */
  private Connection getConnection() throws SQLException {
    String jdbcUrl = "jdbc:mysql://localhost/watw-test";
<a id="fix"></a>//  jdbcUrl += "?useLegacyDatetimeCode=false&amp;serverTimezone=UTC";
    final Connection retval = DriverManager.getConnection(jdbcUrl, 
        "testuser", "test123");
    return retval;
  }

  /**
   * Given a Calendar, inserts a text, datetime, and timestamp version of the
   * Calendar timestamp in the database.
   */
  private void insertDateTime(final PreparedStatement insertStatement,
      final Calendar cal, final DateFormat df) throws SQLException {
    int index = 1;
    insertStatement.setString(index++, df.format(cal.getTime()));
    final Timestamp timestamp = new Timestamp(cal.getTimeInMillis());
    insertStatement.setTimestamp(index++, timestamp);
    insertStatement.setTimestamp(index++, timestamp);
    insertStatement.execute();
  }

}

default-time-zone='+00:00'