title: Grafana/Postgresql: how to convert date stored in UTC to local timezone
body: <p>I have a date stored in postgres db, e.g. <code>2019-09-03 15:30:03</code>. Timezone of postgres is UTC.</p>
  
  <p>When Grafana gets the date, it is <code>2020-09-03T15:30:03.000000Z</code>. If I now run date_trunc('day', <code>2020-09-03T15:30:03.000000Z</code>), I get <code>2020-09-03T00:00:00.000000Z</code>. But, I want midnight in my local timezone.</p>
  
  <ol>
  <li>How do I get the local timezone (offset) in postgres or grafana?</li>
  <li>Could I get the timezone in military style, instead of "Z" for UTC "B"?</li>
  <li>Or can I somehow subtract the offset of the local timezone to get a UTC date corresponding to midnight local time?</li>
  </ol>
  
  <p>Thanks in advance
  Michael</p>