title: How to set time_zone for Source DB in AWS DMS?
body: <p>I am trying to migrate a MySQL database to Aurora, but can't get the timezone set.</p>
  
  <p>According to the <a href="http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.ConnectionAttributes.html#CHAP_Introduction.ConnectionAttributes.MySQL" rel="nofollow noreferrer">documentation</a>: "Valid values are the standard time zone abbreviations for the operating system hosting the source MySQL database."</p>
  
  <p>Executing <em>date</em> on my Linux (Ubuntu) machine shows: <code>Thu Dec  7 10:27:48 AEDT 2017</code>.</p>
  
  <p>I have configured the Source Endpoint to use:</p>
  
  <p><strong>Extra connection attributes</strong>: <em>initstmt=SET time_zone=AEDT</em></p>
  
  <p>Which results in my connection test to fail with:</p>
  
  <pre><code>Error Details: [errType=ERROR_RESPONSE, status=1022502, errMessage=Cannot connect to ODBC provider ODBC general error., errDetails= RetCode: SQL_ERROR SqlState: HY000 NativeError: 1298 Message: [unixODBC][MySQL][ODBC 5.3(w) Driver]Unknown or incorrect time zone: 'AEDT' ODBC general error.]
  </code></pre>
  
  <p>I've tried <code>"Australia/Sydney"</code> as well (same value as in RDS Parameter Groups) but getting the same error.</p>
  
  <p>Any ideas?</p>
  
  <p><em>I am totally aware of that this should be UTC. Not my choice - legacy.</em></p>
  
  <p><strong>Update: It seems <code>initstmt=SET time_zone="+11:00"</code> works, but leading to <a href="https://stackoverflow.com/questions/47687470/timezone-awareness-differences-between-system-tz-and-db-tz">this</a> issue.</strong></p>