title: The difference between Parse and Convert in SQL Server
body: <p>I have a query like this </p>
  
  <pre><code>SELECT ISDATE('18 Mar 2016 18:57:35 GMT');
  </code></pre>
  
  <p>And it returns 0 of course because the string is not a valid date format and again for the same reason when I run </p>
  
  <pre><code>SELECT CONVERT(DATETIME, '18 Mar 2016 18:57:35 GMT')
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>But what I do not understand is that why I can do the same with <code>PARSE</code> function.</p>
  
  <pre><code>SELECT PARSE('18 Mar 2016 18:57:35 GMT' AS DATETIME )
  </code></pre>
  
  <p>I get <code>2016-03-18 14:57:35.000</code> as the result.</p>
  
  <p>Can anyone please tell me how <code>PARSE</code> and <code>CONVERT</code> are different and why I am able to run the query with <code>PARSE</code> and not with <code>CONVERT</code>? Thanks</p>