title: Querying dbconnect returns shifted time results (incorrect time zone)
body: <p>I am interfacing MySQL database on remote server using <code>DBI::dbconnect()</code> function. </p>
  
  <p>When querying for results based on filtering datetime column, the server returns correct results, but they are shifted by +1 hour (fe. 21:00:00 instead of 20:00:00). Both R time zone and server time zone are in <code>CET</code> (+01:00). But the connection acts as if the server time zone was <code>UTC</code> intead. See:</p>
  
  <pre><code>q = dbSendQuery(con, "SELECT NOW(), @@global.time_zone, @@session.time_zone;")
  dbFetch(q)
                  NOW() @@global.time_zone @@session.time_zone
  1 2020-02-21 12:47:56             SYSTEM              +00:00
  
  Sys.time() #System time for R machine
  [1] "2020-02-21 12:48:10 CET"
  </code></pre>
  
  <p>I have tried to set both <code>timezone</code> and <code>timezone_out</code> arguments of <code>dbconnect()</code> to <code>CET</code> but it does not change the query results. </p>
  
  <p>I don't know how else to deal with it apart from substracting an hour from the results after fetching the data to R.</p>