Check if fields in a column are dates and convert them
<p>I am creating a process that will eventually get data from one place and place it into another. For this to happen, I need to transform my data. </p>

<p>I have a column that contains string's and dates</p>

<pre><code>timestamp
20POST /xxxei/adsa/ContentVis HTTP/1.1  Host: fa.aweb.com
2016-12-18T00:15:10.289Z
2016-11-06T04:09:54.503Z
</code></pre>

<p>I was doing this:</p>

<pre><code>select cast(left("timestamp",10) as timestamp)
</code></pre>

<p>but now my process is failing because I didn't account for this, as a value:</p>

<pre><code>20POST /xxxei/adsa/ContentVis HTTP/1.1  Host: fa.aweb.com
</code></pre>

<p>My system doesn't take the function ISDATE(), do you guys have any ideas this cinco de Mayo.</p>