title: snowflake convert string to timestamp
body: <p>I have a timestamp string value from source data which I wanted to convert into required format. Any idea on converting the string into timestamp is much appreciated.</p>
  <pre><code>String value of source data
  'Fri Oct 16 03:27:06 PDT 2020'
  
  I want above string to be converted into 
  YYYY-MM-DD HH24:MI:SS
  
  which should be like from the sample string shared
  2020-10-16 03:27:06
  
  As of now trying with below, but this sounds like not a good practice to have.
  
  select to_timestamp(substr('Fri Oct 16 03:27:06 PDT 2020',5,15)||' '||substr('Fri Oct 16 03:27:06 PDT 2020',25),'MON DD HH24:MI:SS YYYY');
  </code></pre>
  <p>Any help to achieve the desired output would be great. Thanks!</p>