title: Timestamp is not recognized Snowflake
body: <p>I have a string value in snowflake as follows;</p>
  <pre><code>&quot;2018-03-08T22:43:23.848Z&quot;
  
  &quot;2018-03-19T18:56:02.886Z&quot;
  
  &quot;2018-03-06T12:39:57.432Z&quot;
  </code></pre>
  <p>Am trying to convert I into timestamp format using following code;</p>
  <pre><code>TO_TIMESTAMP(col_name::VARCHAR)
  </code></pre>
  <p>I used VARCHAR to get rid of double quotes. But am getting following error;</p>
  <pre><code>Timestamp '{&quot;dayOfMonth&quot;:28,&quot;dayOfWeek&quot;:&quot;WEDNESDAY&quot;,&quot;dayOfYear&quot;:87,&quot;hour&quot;:3,&quot;minute&quot;:13,&quot;month&quot;:&quot;MARCH&quot;,&quot;monthValue&quot;:3,&quot;nano&quot;:493000000,&quot;offset&quot;:{&quot;id&quot;:&quot;Z&quot;,&quot;rules&quot;:{&quot;fixedOffset&quot;:true,&quot;transitionRules&quot;:[],&quot;transitions&quot;:[]},&quot;totalSeconds&quot;:0},&quot;second&quot;:17,&quot;year&quot;:2018}' is not recognized
  </code></pre>
  <p>Kindly advise if my syntax is wrong or there are better ways to handle this error.</p>