title: How to select date from a time range in PostgreSQL?
body: <p>In our Postgres database, we have the following range for a field:</p>
  
  <p>The value looks like this: (some kind of a slot)</p>
  
  <pre><code>["2015-02-06 18:30:00","2015-02-06 19:00:00")
  </code></pre>
  
  <p>We would like out of it to select only the first component: <code>2015-02-06</code></p>
  
  <p>We tried several functions: <code>LEFT</code>, <code>SUBSTRING</code>, <code>TO Char</code> but they are all giving errors.</p>
  
  <p>Any idea how we could solve this?</p>