title: Symfony Doctrine - set time zone
body: <p>I have multiple Symfony applications running on the same sever, and every application may need a different time zone.</p>
  
  <p>For php, it's doable by using different fpm pools and setting the time zone in the pool configuration:</p>
  
  <pre><code>php_admin_value[date.timezone] = America/New_York
  </code></pre>
  
  <p>but for MySQL, I need to issue the statement:</p>
  
  <pre><code>"SET time_zone = 'America/New_York';
  </code></pre>
  
  <p>as the first query after connected, or add to the $options array in the PDO constructor:</p>
  
  <pre><code>PDO::MYSQL_ATTR_INIT_COMMAND =&gt; "SET time_zone = 'America/New_York';"
  </code></pre>
  
  <p>How can this be done?</p>