title: Grafana - unable to use unix as a timestamp? PostgreSQL
body: <p>I'm trying to set up a grafana based on PSQL data source, but I can not make grafane use UNIX timestamps for some reason. Here is a sample table, which is connected to grafana:</p>
  <pre><code>ticks=# select * from btc_usd limit 10;
  time_stamp   |  quote  |   volume
  ---------------+---------+------------
  1632793114709 | 42373.9 |  0.0231421
  1632793114929 | 42372.2 |   0.011807
  1632793115546 | 42373.9 | 0.00386025
  1632793116352 | 42373.9 |  0.0011276
  1632793116480 | 42372.4 |  0.0161129
  1632793116513 | 42372.2 |  0.0358965
  1632793116513 | 42372.2 |  0.0134995
  1632793116513 | 42371.9 | 0.00990016
  1632793117768 | 42373.8 | 0.00058705
  1632793117808 | 42373.8 | 0.00221274
  </code></pre>
  <p>(called locally from postgres db)</p>
  <p>And here are some queries I've tried so far in grafana:</p>
  <pre><code>SELECT * FROM btc_usd;
  
  SELECT time_stamp AS &quot;time&quot;, quote FROM btc_usd;
  
  SELECT STR_TO_DATE(time_stamp,'%Y-%m-%d %H:%i:%s') AS 'time', quote FROM btc_usd;
  </code></pre>
  <p>No matter what I try, Grafana is throwing:</p>
  <pre><code>Data does not have a time field
  </code></pre>
  <p>and wont chart anything :/</p>
  <p>Im able to display data as a table:</p>
  <p><a href="https://i.stack.imgur.com/E9KsG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E9KsG.jpg" alt="enter image description here" /></a></p>