title: Querying date/time from PostgreSQL into R
body: <p>I am using a computer in London to scrape data from an API. The data/time that the API gives me is in UTC.</p>
  
  <p>I insert the data into a PostgreSQL server which is based in New York.</p>
  
  <p>I then extract data from the PostgreSQL server into my laptop, again, based in London.</p>
  
  <p>Some confusion is happening and I'm struggling to resolve it.</p>
  
  <p>PostgreSQL directly using PgAdmin:</p>
  
  <pre><code>SELECT max(date_time) FROM my_table
  "2019-10-11 20:22:04-05"
  </code></pre>
  
  <p>When in an R query using RPostgreSQL:</p>
  
  <pre><code>dbGetQuery('SELECT max(date_time) FROM my_table')
  "2019-10-12 02:22:04"
  </code></pre>
  
  <p>Anyone got any ideas on what is going on and how to resolve this? I want to work in UTC.</p>