title: How to remove TimeZone in query to_timestamp Postgresql
body: <p>I'm finding in Postgresql and I want to remove <code>+9</code> UTC value in my query.</p>
  
  <p><strong>For example:</strong> In to_timestamp column, I want to remove <code>+09</code>, and only keep <code>2016-02-26 00:23:44</code> value.</p>
  
  <p>This is my query: </p>
  
  <p><code>select t,to_timestamp(v) from c1.hour where f = 22 and date_trunc('day',t - '1 hour'::INTERVAL) = '2016-02-26 00:00:00' order by t ;</code></p>
  
  <p>Here my result:
  <a href="https://i.stack.imgur.com/idWw4.png" rel="noreferrer"><img src="https://i.stack.imgur.com/idWw4.png" alt="enter image description here"></a></p>
  
  <p>And this is my result when I didn't use to_timestamp:
  <a href="https://i.stack.imgur.com/ZhnOn.png" rel="noreferrer"><img src="https://i.stack.imgur.com/ZhnOn.png" alt="enter image description here"></a></p>
  
  <p>Can I get some help on this please?</p>