title: Mysql: Set time_zone for select queries, UTC for everything else
body: <p>Is it possible to configure MySQL (at runtime) to use UTC for all write queries, but another timezone for all <code>SELECT</code> queries?</p>
  
  <p>I'm storing all dates in UTC (additionally, the app will always pass UTC datetimes to MySQL) and have MySQL configured to be running in UTC (using <code>SET time_zone = '+0:00'</code>); but is there a way for it to automatically translate all <code>SELECT</code> into another timezone?</p>
  
  <p>I realise I can do this in code, but if I can make MySQL do the job for me that'd be much easier.</p>
  
  <p>To be clear: I'd also like to just run a command once, not use any of the date/time formatting functions for each query.</p>