How to select date from a time range in PostgreSQL?
<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>