title: Mysql is not converting timestamp to the timezone of PHP query
body: <p><a href="https://i.stack.imgur.com/taHfr.png" rel="nofollow noreferrer">I have a mysql database in this format</a></p>
  
  <p>And I am trying to fetch the values through a php document and convert them into json on the timezone of the user (or maybe just GMT-6 would suffice) but the json outputs from the php document are as follows: </p>
  
  <pre><code>[{"timestamp":"2018-06-13 19:52:05","temperature":"79.83","humidity":"41.89","pressure":"99.35"},{"timestamp":"2018-06...
  </code></pre>
  
  <p>Still in UTC time, I have tried adding </p>
  
  <pre><code>date_default_timezone_set('America/Los_Angeles');
  </code></pre>
  
  <p>To the php document, but the time never changes, how would I solve this?</p>