title: How to change the time zone on a query result
body: <p>I have the following query that works as intended -</p>
  <pre><code>SELECT
  max(CASE WHEN `label` = 'Order Number' THEN `response` else '' END)as `Order Number`,
  max(CASE WHEN `label` = 'Date' THEN `response` else '' END)as `Date`,
  max(CASE WHEN `label` = 'Creditor Name' THEN `response` else '' END)as `Creditor Name`,
  max(CASE WHEN `label` = 'Purchaser' THEN `response` else '' END)as `Purchaser`,
  max(CASE WHEN `label` = 'Farm' THEN `response` else '' END)as `Farm`,
  max(CASE WHEN `label` = 'Quantity' THEN `response` else '' END)as `Quantity`,
  max(CASE WHEN `label` = 'Description' THEN `response` else '' END)as `Description`,
  max(CASE WHEN `label` = 'Allocation' THEN `response` else '' END)as `Allocation`
  From `inspection_items`
  where `template_id` = 'template_xxxx' and `type` not like 'section' and `type` not like 'information' and `type`not like 'element' and `type` not like 'dynamicfield'
  group by `parent_id`, `audit_id`
  order by `created_at`,`item_index`
  </code></pre>
  <p>However I also need to change the date which I can do by this query -</p>
  <pre><code>SELECT `response`, Date_format(Convert_TZ(STR_TO_DATE(`response`, '%Y-%c-%dT%H:%i:%s'), '+00:00', '+10:00'), '%Y-%c-%d %H:%i:%s') as 'Date'
  from `inspection_items`
  </code></pre>
  <p>However how do I bring these 2 queries together to change the date in the first query result?</p>